Question

In: Computer Science

Normalize the following data by: a) identifying the functional dependencies, b) stating your assumptions, \ c)...

Normalize the following data by:

a) identifying the functional dependencies,

b) stating your assumptions, \

c) creating relations, and

d) identifying primary and foreign keys.

Customer Number| First Name |Last Name |Phone | Invoice Number| Date |Item Type |Quantity Item Price

Solutions

Expert Solution

As the given data is

Customer Number| First Name |Last Name |Phone | Invoice Number| Date |Item Type |Quantity Item Price.

now the solutions are:

a) identifying the functional dependencies :

ans: a functional dependency is defined as the realtionship between the two attirbutes in a data, so generally this functional dependency will be created between the primary key and the non-key attribute.

so from the above given data then functional dependency will be the customer first name.
becuase here the primary key is the Customer Number and by using Customer number it is easy to find the customer first name. so customer first name is the functional dependency.

b) stating your assumptions

the assumptions are defined as the events which appears during a project start to end cyle process and they will throughly analysed. the assumption condition will always be true in the starting and it plays a key role in completing a project with less disturbances.

so from the given data the assumption will helps in creating the analysing the data perfectly.


c) creating relations,

generally the relations are defined as representing a parituclar data with a specific character. now in sql tables relations are defined as the tables where a table is considered as single tuple and the values in each attribute will be considered as a column.

so from the given above data the whole table will be considered as single tuple.

d) identiying the primary key and foriegn key

primary key is defined as the key where it is used as a unique identifer to retrieve the data.
the features of primary key are:
1. it has a unique value
2. it should not contain null values.
3. there should be only one primary key in a table.

so from the above given table the primary key is Customer Number

foreign key is defined as the key which is used as a link between the tables. the foriegn key in one table is used to match the primary key in another table.

so from the above given data the foriegn key is Invoice number.


Related Solutions

For the relation R(A,B,C,D,E) with the following Functional Dependencies: A → B, A → C, BC...
For the relation R(A,B,C,D,E) with the following Functional Dependencies: A → B, A → C, BC → D, AC → E, CE → A, list all non-trivial FDs following from the above.    Generate all possible keys for R. Check whether R is in 3NF. If it is in 3NF, explain the criteria you used. If it is not in 3NF, convert it into 3NF, showing the new relations and their FDs.
Normalize the following relations. Show possible candidate/primary keys and the functional dependencies. Explain the normal form...
Normalize the following relations. Show possible candidate/primary keys and the functional dependencies. Explain the normal form in which the relation is currently in (based on the sample data) and how do you break the relations to get 3rd Normal Form. Show the new relations obtained after normalization and underline the candidate/primary key in each new relation and italic the foreign key. Relation 1: COLLEGE PARKING TICKET (STID, LName, FName, PhoneNo, StateLic, LicNo, Ticket#, Date, Code, Fine) (Illustrated with sample data)...
1. When stating that "A=B and B=C, then A=C" the _______ of the thermodynamics. A. First...
1. When stating that "A=B and B=C, then A=C" the _______ of the thermodynamics. A. First B. Second C. Third D. Zeroth 2. "It is impossible for a process to have as it sole result the transfer of heat from a cooler body to a hotter one." This statement represents the _____ Law of Thermodynamics. A. First B. Second C. Third D. Zeroth 3."It is impossible to reduce any system to absolute zero in a series of      operations. This...
Consider a relation R (ABCDEFGH) with the following functional dependencies: ACD --> EF AG --> A...
Consider a relation R (ABCDEFGH) with the following functional dependencies: ACD --> EF AG --> A B --> CFH D --> C DF --> G F --> C F --> D Find minimal cover and identify all possible candidate keys. In order to receive full credit, please list each step taken and the rules that you applied.
Determine the Functional Dependencies that exist in the following Orders table. This table lists customer and...
Determine the Functional Dependencies that exist in the following Orders table. This table lists customer and order data. Orders (SupplierNum, SupplierName, Supp_Phone, ProductNum, Description, Product_type, QuotedPrice) . Normalize the above relation to 3 rd normal form, ensuring that the resulting relations are dependency-preserving and specify the primary keys in the normalized relations by underlining them.
Consider the following functional dependencies: Z -> XYD, X -> Y. Find the minimal cover of...
Consider the following functional dependencies: Z -> XYD, X -> Y. Find the minimal cover of the above.
a. Determine the functional dependencies that exist in the following table. Orders (OrderNum, OrderDate, ItemNum, Description,...
a. Determine the functional dependencies that exist in the following table. Orders (OrderNum, OrderDate, ItemNum, Description, NumOrdered, QuotedPrice) b. After determining the functional dependencies, perform 1nf, 2nf, 3nf.
1. Consider the following functional dependencies: Z -> XYD, X -> Y Find the minimal cover...
1. Consider the following functional dependencies: Z -> XYD, X -> Y Find the minimal cover of the above. 2. Consider the following two sets of functional dependencies: F = {A -> C, AC -> D, E -> AD, E -> H} and G = {A -> CD, E -> AH}. Check whether they are equivalent.
What are the minimum and maximum of the following dataset? Normalize these data so that the...
What are the minimum and maximum of the following dataset? Normalize these data so that the normalized data have a minimum of 0 and maximum of 1. •   5.0, 5.5, 6.2, –4.8, 7.2, 5.4
Normalization: Answer all 4 questions. You are given the following relation R and some functional dependencies....
Normalization: Answer all 4 questions. You are given the following relation R and some functional dependencies. R(SID, Project, Code, ListOfSupplies, Name, Initials, Abbrev) Project → ListOfSupplies SID → Name Name → Initials Project, Initials → Abbrev SID, Project → Code Code → SID Is R in 1NF? If not, normalize R into a collection of 1NF relations. Is R in 2NF? If not, normalize R (or your collection of 1NF relations) into a collection of 2NF relations. Is R in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT