Question: For each relation: a) List Functional Dependencies. b) Based on the given primary key, is the relation in 1NF, 2NF, or 3NF?Why or why not?

For each relation:

a) List Functional Dependencies.

b) Based on the given primary key, is the relation in 1NF, 2NF, or 3NF?Why or why not?

c) Normalize the relation successively into 3NF, if it is not already in 3NF.

You may present the normalized relations using the kind of notation seen in the FACULTY or ORDER relations below, or you could use the kind of notation used when drawing relational schemas (e.g., with table headers).

FACULTY(FacNo, FacName, DeptNo, DeptName, DeptLoc, InsurPlanNo, InsurPlanDesc)

ORDER(OrdNo, OrdDate, CustNo, PartNo, Qty, UnitPrice)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Database design (normalisation..1NF ,2NF, 3NF) Part Two (Normalisation The LIVER DATABASE Company in Liverpool wishes to allocate staff to a new development project that has been proposed by external...

Listing Dependencies EMPLOYEEEMP NUM, EMP NAME, JOB_CLASS, CHG HOUR) Page 1 of 2 FIGURE 6.3 FIRST NORMAL FORM (1NF) DEPENDENCY DIAGRAM Full: Transitive (JOB_CLASSCHG_HOUR) EMP NUMEMP NAME ASSIGNMENT...

Consider primary key based normalization only. Given a relation R(A, B, C, D, E, F, G, H, I, J) with primary key AB, and the set of functional dependencies (FDs) AB->C, A->DE, B->F,...

Normalization Q . 1 : Given the relationBook _ Pub _ Author ( Title , PubId, AuId, Price, AuAddress ) The functional dependencies are given below . 1 . Key { Title , PubId, AuId } 2 . { Title ,...

Normalization is the process of minimizing redundancy from a relation or set of relations. Redundancy in relation may cause insertion , deletion , and update anomalies . Normal forms are used to...

Consider the following relation: CAR_SALE(Car#, Date_sold, Salesperson#, Commission%, Discount_amt) Assume that a car may be sold by multiple salespeople, and hence {Car#, Salesperson#} is the...

Consider the following relation: CAR_SALE(Car#, Date_sold, Salesman#, Commision%, Discount_amt Assume that a car may be sold by multiple salesmen and hence {CAR#, SALESMAN#} is the primary key....

a) Explain THREE (3) advantages of performing normalization. (3 Marks) b) Describe the major steps in the normalization process. (4 Marks) c) Examine Table 1 that shown below and answer all questions...

c) Examine Table 1 that shown below and answer all questions given. i. List all functional dependencies for Table 1. (3 Marks) ii. Based on the functional dependencies identified in (i), produce the...

Briefly answer the following questions: 1. Define the term functional dependency. 2. Why are some functional dependencies called trivial? 3. Give a set of FDs for the relation schema R(A,B,C,D) with...

a) How would the following conditions affect the minimum stopping sight distance requirement? i. A driver with blurred vision ii. A vehicle with worn out tyres b) Identify the functional classes of...

Solve Problem by summing the rectangular or x. y components of the forces to obtain the resultant force.

7. Briefly describe the valuation of (a) biological assets and (b) agricultural produce.

Julian Birkinshaw, James Manktelow, Vittorio DAmato, Elena Tosca, and Francesca Macchi In recent years, one of the most profound transformations in the workplace has been the increase in age...