Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not to Third Normal Form, explain why. Discuss PK and FK for each relation.Data Dictionary that translates your relational data structures, which includes (as in the picture):table names,column names and field typesprimary keys identified A SAMPLE DATA DICTIONARYFKREFERENCEDTABLE NAME ATTRIBUTE NAMECONTENTSΤΥΡEFORMATRANGEREQUIRED PK OR FK TABLECUSTOMERCUS_CODECustomer account code CHAR(5)9999910000-99999YPKCUS_LNAMECustomer last nameVARCHAR(20) XxxxxxxxYCUS_FNAMECustomer first nameVARCHAR(20) XxxxxXXxYCUS_INITIALCustomer initialCHAR(1)XCUS_RENEW_DATECustomer insuranceDATEdd-mmm-yyyyrenewal dateAGENT_CODEAgent codeCHAR(3)999FKAGENTAGENTAGENT_CODEAgent codeCHAR(3)999YPKAGENT_AREACODEAgent area codeCHAR(3)999YAGENT_PHONECHAR(8)Agent telephonenumber999-9999YAGENT_LNAMEAgent last nameVARCHAR(20) |ХхXXXXXXYAGENT_YTD_SLSAgent year-to-date sales NUMBER(9,2)9,999,999.99FK= Foreign keyPK= Primary keyCHAR= Fixed character length data (1 – 255 characters)VARCHAR= Variable character length data (1 – 2,000 characters)= Numeric data. NUMBER (9,2) is used to specify numbers with up to nine digits, including two digits to the right of the decimal place. SomeRDBMS permit the use of a MONEY or CURRENCY data type.NUMBER

Although Second Normal Form (2NF) relations have less redundancy than those in 1NF, they may still…

Answered: Draw the Dependency Diagram that is in…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not to Third Normal Form, explain why. Discuss PK and FK for each relation.
Data Dictionary that translates your relational data structures, which includes (as in the picture):

1. table names,
2. column names and field types
3. primary keys identified

A SAMPLE DATA DICTIONARY
FK
REFERENCED
TABLE NAME ATTRIBUTE NAME
CONTENTS
ΤΥΡE
FORMAT
RANGE
REQUIRED PK OR FK TABLE
CUSTOMER
CUS_CODE
Customer account code CHAR(5)
99999
10000-99999
Y
PK
CUS_LNAME
Customer last name
VARCHAR(20) Xxxxxxxx
Y
CUS_FNAME
Customer first name
VARCHAR(20) XxxxxXXx
Y
CUS_INITIAL
Customer initial
CHAR(1)
X
CUS_RENEW_DATE
Customer insurance
DATE
dd-mmm-yyyy
renewal date
AGENT_CODE
Agent code
CHAR(3)
999
FK
AGENT
AGENT
AGENT_CODE
Agent code
CHAR(3)
999
Y
PK
AGENT_AREACODE
Agent area code
CHAR(3)
999
Y
AGENT_PHONE
CHAR(8)
Agent telephone
number
999-9999
Y
AGENT_LNAME
Agent last name
VARCHAR(20) |ХхXXXXXX
Y
AGENT_YTD_SLS
Agent year-to-date sales NUMBER(9,2)
9,999,999.99
FK
= Foreign key
PK
= Primary key
CHAR
= Fixed character length data (1 – 255 characters)
VARCHAR
= Variable character length data (1 – 2,000 characters)
= Numeric data. NUMBER (9,2) is used to specify numbers with up to nine digits, including two digits to the right of the decimal place. Some
RDBMS permit the use of a MONEY or CURRENCY data type.
NUMBER

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions