[go: up one dir, main page]
Scribd
Upload
10 views3 pages

Lab6

Uploaded by

Abc
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views3 pages

Lab6

Uploaded by

Abc
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

TDB1131 Database Systems

Tutorial 6
Topic: Normalization

1. The dependency diagram below indicates that authors are paid royalties for each book that
they write for a publisher. The amount of the royalty can vary by author, by book, and by
edition of the book. Based on the dependency diagram, create a database whose tables are
at least in 3NF, showing the dependency diagram for each table.

2. Given the following attributes. Normalize the dependency to 2NF.

Cust_IC Cust_Name Cust_Phone Cust_Email Invoice_Num Quantity Products Date

3. Based on the figure below, answer the following questions:


ClientRental

i. Please identify the repeating groups.


ii. Normalize the table to 1NF.
iii. In your opinions, what should you do to solve the data redundancy that still exists
in 1NF?

iv. Based on your answer in iii), please list down your solution.
v. Is there any transitive dependency? If yes, please show the solution of
normalization.

Page 1 of 3
TDB1131 Database Systems

Figure 1. Order Form

4. Figure 1 is an order form from a shop. Normalisation process is needed to verify the design
of the database system. Please answer the following questions accordingly.
i. What is the main goal of normalisation process?

ii. Please identify the composite keys and attributes of first normal form.
iii. Based on Figure 1, please produce second and third normalisation form.
Remember to indicate primary key and foreign keys.

5. Given the following relational schema and STU_NUM is the only primary key.
STUDENT (STU_NUM, STU_LNAME, STU_FNAME, STU_MAJOR,
DEPT_CODE, DEPT_NAME, DEPT_PHONE, COLLEGE_NAME,
ADVISOR_LNAME, ADVISOR_FNAME, ADVISOR_OFFICE, ADVISOR_BLDG,
ADVISOR_PHONE, STU_GPA, STU_CREDIT_HOURS, STU_SUBJECTS)

i. Are there any partial dependencies in the STUDENT relational schema? Please
write down if any.
No.
ii. Are there any transitive dependencies in the STUDENT relational schema? Please
write down if any.

iii. Based on your answer in i and ii, add in necessary attributes to complete the design
of database.

Page 2 of 3
TDB1131 Database Systems

Quotes of the day:


“The only source of knowledge is the experience.” – Albert Einstein

Page 3 of 3

You might also like