0
votes
1answer
29 views

database normalization to 3NF

I am just at a complete lost. I need help with this. There should be 12 tables (or perhaps 11 since one table has just a single attribute) when you are finished with the normalization and merging of ...
0
votes
0answers
12 views

Trying to get BCNF out of this relation

The table is: Employee ( EID, Ename, PID, ProjectName, MID, ManagerName ) For the functional dependencies I got: EID==>(Ename) PID==>(ProjectName) ...
2
votes
6answers
428 views

Database Normalization - Can one field point to another?

This may sound like a dumb question, but I am a software developer new to database design... So the concept makes sense to me, but maybe this doesn't carry-- Is it possible for a field in a record ...
0
votes
1answer
38 views

Normalization of Time Series Data

I have a table containing various a/b test experiment performance on a daily basis. The table structure looks something like this: date | experiment | user_count | user_attr | sales ...
0
votes
1answer
47 views

Train Fare Database Normalisation

I have a database to normalize. The database has details of train ticket fares. The trains have different fares depending on the distance and I have to store these fares in the database It is not an ...
0
votes
2answers
35 views

Does this break normalization?

I have an order table, and in the order table I have a contact_id. Now, each contact is linked to an account. For my order table, should I have both contact_id and account_id? If I wanted to say, ...
1
vote
2answers
112 views

When normalizing a relational database, should multiple “type” tables be combined into one?

Before making substantial changes to the content, functionality and design of my website (I'll be refactoring everything, almost a complete rewrite), I'm setting up a new PostgreSQL database to hold ...
2
votes
1answer
39 views

Confusion normalizing data to 3NF and transitive dependencies

I am currently in a Database class and have some confusion with normalizing to 3NF. I have one specific issue that was not addressed in class but appears in the book problems. For example I have R ...
0
votes
1answer
79 views

Airport Database Design guidance required

I am trying to make a generic database for airport management and DBMS would be oracle 11g xe. Since, i am amateur and still learning so i have tried to kept the problem statement simple with limited ...
0
votes
0answers
17 views

loading k:v pairs from DB into JS Object

I'm creating a single player web RPG. I'm debating the following method of storing/retrieving quest items per player id: In userstats table, have a quest_items column of type mediumtext, where I ...
1
vote
1answer
55 views

Rules for Decomposition to 2 NF

I am struggling with the concept of 2NF form. Lets say I have a set of functional dependencies for R1(A,B,C,D,E,H,M,K) Where : B -> M,C AB -> D DH -> E H -> K A -> H Whenever I ...
0
votes
1answer
93 views

Airline reservation system [closed]

I'm making a simple airline reservation system. But I'm not sure about the design decisions I made. Concretely, I'm trying to implement following constraints: each Aircraft can have one or more ...
0
votes
0answers
24 views

Normalization to BCNF help needed

I have a table with 5 columns as A, B, C, D, and E. The functional dependencies are: AB -> C,D,E BCD -> A BCE -> A,D BD -> E I think AB is the candidate key. I can't find any other candidates. ...
0
votes
0answers
69 views

Database normalization tables

I am creating a database for a very basic website. I have created the tables and put what I thought might be the correct schema, however I am having doubts about it as well as a couple problems. All ...
1
vote
0answers
22 views

Difference in the workload related to data-amount and search option

A couple of days ago I was asked why it is necessary to use the first normal form also for separation of names. We have a table which stores private customers (Name+Surname;Information) and business ...
1
vote
1answer
44 views

Decomposing into 2NF

I'm currently studying normalization. I know how to normalize the data for given unnormalized list. But I found this question in our past papers. I don't know how to answer to it. Q. Decompose ...
1
vote
1answer
36 views

UK Addresses in 3NF

I am in the process of creating a UK only database which holds information for various sets of people i.e. Staff, Clients etc. The tables for each of these sets of people have an Address, City and ...
1
vote
1answer
77 views

Is this design in 3NF? Why to choose another design not in 3NF

Having the following entities: Objects, Parts, Subparts and Items, and given the following design restrictions: A Part belongs to one and only one Object. A Subpart belongs to one and only one Part. ...
0
votes
0answers
44 views

How to convert this relation to 2NF?

In my Entity Relationship Diagram, an entity type TEACHER had a relationship of TEACH with another entity type called CLASS. CLASS was a week entity type of TEACHER,so when mapping to a Relational ...
1
vote
1answer
63 views

Database Over Normalized [closed]

How can you tell when a database is over normalized? Example: I have a database for employee. These are the following tables involved: User - contains email, password, companyId Profile - ...
0
votes
1answer
46 views

Attempting to identify transitive dependency

Hello I am attempting to identify a transitive dependency in the following diagram. I think that possibly the determinate of "Subtotal" is "Quantity" and "Price Charged" but I'm not sure if "subtotal" ...
0
votes
1answer
37 views

Design for hierarchical embedded database

The goal is to construct a hierarchical database of Objects having the following format: TypeA -> ObjectA [values, contains ObjectB*, ObjectC*, etc.] TypeB -> ObjectB [values, contains ...
1
vote
1answer
54 views

Need some recommendations on organizing data

I'm new here. This question, to my mind, is allowed by the rules I saw in the "2 minute tour". If I got it wrong, no need for nasty grams. I'll delete if enough people say so. But anyway, I have a ...
1
vote
2answers
119 views

To normalize or not to normalize for few distinct values

Assuming in a Postgres database, you have a table called party, which can have less than 5 well-defined party_types such as 'Person' or 'Organization'. Would you store the party_type in the party ...
1
vote
0answers
110 views

Can somebody check this normalisation workings i think i am missing a step or a dependency somewhere

given these two tables: and: I need to first list them as an un-normalised structure(s) then i need to identify the functional dependencies/primary keys. Once i have done this i must represent ...
1
vote
2answers
128 views

Can somebody help me normalise this database/check my workings

I am new to database design/normalisation and functional dependencies. I have started a new database class in school this week and we have been given a worksheet that requires the following: This is ...
1
vote
1answer
137 views

Functional dependencies and candidate key example [on hold]

Hi there I'm still learning for my examination and I got this exercise: A table is given: F-Name, F-Nation, Team-Name, Team-Nation ...
1
vote
4answers
151 views

How to handle table design with variable columns

I have a table design scenario and as a non-DBA type, would like opinions on which is more scaleable. Say you are asked to record information on houses for a metro area, starting with a small ...
0
votes
0answers
173 views

Normalizing data to 3NF

I need some help with normalization. Here is the data in 0NF : **HOSPITAL SERVICES (date_hospitalization , id_patient , id_doctor , name , surname , PIN, duration_of_hospitalization , ...
1
vote
1answer
178 views

Can Anyone please review my database after I did the Normalization ?.Any suggestion is appreciated

User: User_ID,user_name,E-mail Staff: User_ID,Fname,Lname,DOB Student: User_ID fname Lname DOB Lecture: User_ID Admin: User_ID Position ID : P_ID,ROLE_NAME, Staff_position ...
3
votes
2answers
48 views

Best design for a many:many relationship issue

We have three types of entity, each with their own table: table:A(a_id), table:B(b_id), table:C(c_id) Each of these entities can have any number of email addresses and linked Twitter accounts. ...
0
votes
2answers
167 views

Decomposition of a relation to 2NF and 3NF

I am trying to solve this example, but for now I can't. Can somebody show me, step by step how to decompose this to 2NF and then to 3NF? R = {ABCDEF, ABC -> EF, B -> E, E -> D} key of this ...
0
votes
1answer
67 views

Normalise an expenditure table in a budget database [closed]

We have a budget database that stores expenditure items per budget. There are over 100 expenditure items each having common attributes: Amount, Frequency, Comment. The table will have over 300 ...
2
votes
3answers
184 views

Database design for bookmark system

I am creating a bookmark system where people can save their bookmarks. Each user has its own personal page with bookmarks. A bookmark should have atleast one tag and max five. Each user can create ...
2
votes
1answer
173 views

Two-column foreign key constraint only when third column is NOT NULL

Given the following tables: CREATE TABLE verified_name ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, email TEXT NOT NULL, UNIQUE (name, email) ); CREATE ...
2
votes
1answer
111 views

To normalize or not to normalizde? (10 fields)

I'm helping someone to design a database and for a specific case I'm not sure. I have 10 fields - this will never change - that will always be filled and used in every query that could be coming up. ...
0
votes
0answers
28 views

How to find a projection on the functional dependency?

I have below dependencies on attribute PUT: P -> QR T -> WV R -> UV V -> P Now how to find a projection on the above functional dependencies? I am trying to find a article which can ...
1
vote
1answer
53 views

Is this table designed properly

I am trying to model the process of where one co-worker enters a statement of their proposed work procedure and another co-worker commenting and approving the statement. Currently I have one table as ...
3
votes
1answer
136 views

If all variables are a subset of the candidate key, is the database design 5NF?

I have a table called LogMessages, which has the following columns: Level A numeric value which represents Trace, Debug, Info, Warning, Error or Fatal Time A UTC time Message Foreign key to a ...
3
votes
2answers
116 views

Simple table normalisation

In raw form, I have data with 2 columns: skills in welsh and stats for that skill. For storing these information in a database, would it be best to combine the stats with the categories, or split ...
2
votes
2answers
137 views

Normalizing nearly identical tables

Background I'm managing a relatively small database project in which we are adding support for reporting involving status updates for items in out product table. I was bit thrown into this and I've ...
1
vote
2answers
103 views

Relations, dependencies and normal form

I have some issues in understanding about relations and dependencies. I will show two examples and what I want to know: Assume the relation GTX {G,T,X} with the following dependencies: G,X -> T ...
0
votes
1answer
98 views

store country name or country id [closed]

I am designing a database layout for a site. Agents registering on the site will have to enter their address including the country. Later I will build a dashboard where you would be able to ...
1
vote
1answer
789 views

School database design

I am trying to design a database management system with my PHP and intermediate MySQL knowledge, keeping normalization in mind. These are the assumptions: The school has many students from grade 1 ...
2
votes
3answers
181 views

Database design for conditional detail table

I have an expense management system for monthly expenses. Expenses are of two types: one-time monthly expenses, and daily expenses for each day of month. I have created the following tables: ...
2
votes
2answers
135 views

Design consideration regarding state handling: how to store multiple, variable states for one entity [closed]

First I have to admit that I'm not a database professional neither are my colleagues. For a new project my colleagues and me came to a design question we couldn't really solve easily. And all the ...
6
votes
4answers
507 views

How can a database be normalized when an optional field causes denormalization?

Suppose you have a warehouse full of widgets. Each widget in the warehouse is stored in a specific identifiable location within the warehouse. You might have a schema which looks like this: A ...
0
votes
3answers
96 views

Column partially determining accepted values of another column, should be somehow normalized?

I have a table that describes a set of properties (yes it's metadata, in this case there's a valid reason to have it in the database); among other things I tell the type of the data that can be ...
1
vote
1answer
241 views

Record with variable number of columns?

I am trying to model a cable mapping for devices. Each device has multiple cards, and each of those cards has multiple ports. Since both the number of cards and ports vary, I am confused on how to ...
1
vote
2answers
284 views

Refactoring/normalization - but almost empty table

I normalized a legacy DB into this structure: But I'm not sure if it is correctly normalized. I don't feel very comfortable with the almost empty filters table. The requirements A group contains ...