Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level
No answer yet for this question.
Ask a Tutor
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 Workshop Slide: Session 3, Slide 23):
- table names,
- column names and field types
- primary keys identified
Transcribed Image Text:
A SAMPLE DATA DICTIONARY FK REFERENCED TABLE NAME ATTRIBUTE NAME CONTENTS TYPE CUSTOMER CUS_CODE CUS_LNAME Customer account code CHAR(5) Customer last name VARCHAR(20) XXXXXXXX CUS_FNAME Customer first name VARCHAR(20) XXXXXXXX FORMAT RANGE 99999 10000-99999 Y Y Y REQUIRED PK OR FK TABLE PK 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 AGENT AGENT_CODE Agent code CHAR(3) 999 Y FK AGENT PK AGENT_AREACODE Agent area code CHAR(3) 999 Y AGENT_PHONE Agent telephone CHAR(8) 999-9999 Y number AGENT_LNAME Agent last name VARCHAR(20) XXXXXXXX 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 NUMBER =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. A SAMPLE DATA DICTIONARY FK REFERENCED TABLE NAME ATTRIBUTE NAME CONTENTS TYPE CUSTOMER CUS_CODE CUS_LNAME Customer account code CHAR(5) Customer last name VARCHAR(20) XXXXXXXX CUS_FNAME Customer first name VARCHAR(20) XXXXXXXX FORMAT RANGE 99999 10000-99999 Y Y Y REQUIRED PK OR FK TABLE PK 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 AGENT AGENT_CODE Agent code CHAR(3) 999 Y FK AGENT PK AGENT_AREACODE Agent area code CHAR(3) 999 Y AGENT_PHONE Agent telephone CHAR(8) 999-9999 Y number AGENT_LNAME Agent last name VARCHAR(20) XXXXXXXX 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 NUMBER =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.
Expert Answer:
Posted Date:
Students also viewed these databases questions
-
A firm has a beta of .45.The current market return is 13% while the current return on Treasury securities is 5.2%.The firm is considering a project that will cost $2 million and have expected...
-
Given the sample records in the CHARTER table shown, do the following: Table - CHARTER Attribute Name Sample Value Sample Value Sample Value Sample Value CHAR_TRIP 10232 10233 10234 10235 CHAR_DATE...
-
toyota is considering two projects its hurdle rate is 10% and project after tax cash flows would be 0 1 2 3 4 projects A 30 50 10 15 20 project B 30 20 10 8 6 Calculate payback period Discounted...
-
A drillstring is composed of 9,000 ft of 5-in. 19.5-lbm/ft drillpipe and 1.000 ft of drill collars having a 3.0-in. ID. Compute these items: a) (5 pts) Capacity of the drillpipe in barrels. b) (5...
-
Morgan City Fire Chief Sidney Pyro is concerned about the low efficiency scores that his firefighters receive at the state testing institute. Chief Pyro believes that these scores result because some...
-
What are some of the potential gains from leasing if the lessee plans to hold the asset for only a small fraction of its useful life?
-
A call will be in the money if: a. S>E b. S. E d. C,
-
(Liberatore and Miller, 1985) A manufacturing facility uses two production lines to produce three products over the next 6 months. Backlogged demand is not allowed. However, a product may be...
-
1) For 9 points, sketch f(x)= secx over the half-open interval [-7, 2). 2 -3/2 1- -"/2 1 "/2 3/2 2 5x12
-
Neo Bank, a traditional commercial bank, is exploring the feasibility of offering a new insurance underwriting service. Mr. Nathan, the CEO of Neo Bank says that the offering of the new services...
-
A troublesome power generator fails randomly at an average rate of 6 times per year. Use the Poisson distribution to calculate the % probability that the number of failures in a period of 3 years...
-
Toonces the driving cat is piloting a 4000lbf car with 16 tiresat 40mph on flat ground. The car has bias?ply tires. The carsweight is evenly distributed among its 4 tires. At a certainmoment, the...
-
Two carts have the same mass. Both carts start at rest and are pushed until one cart is going two times faster than the other cart. How much more work was done on the cart that is going faster? One...
-
Visions designs, markets, and distributes audio and gaming headphones, earbuds, and speakers. Assume that last year, Visions reported cost of goods sold of $171 million. Assume that this year, cost...
-
Lopez Company is considering replacing one of its old manufacturing machines. The old machine has a book value of $ 4 7 , 0 0 0 and a remaining useful life of four years. It can be sold now for $ 5 7...
-
Describe the scope of the dental hygiene diagnosis as it relates to building a practice.
-
Audrey purchases a riding lawnmower using a 2-year, no-interest deferred payment plan at Lawn Depot for x dollars. There was a down payment of d dollars and a monthly payment of m dollars. Express...
-
Ignoring tax issues, would a shareholder with a 51% controlling interest in a company be better off buying another company or merging with it?
-
Is the dilution of EPS that follows all mergers generally greater or less than that which follows a standard capital increase?
-
Why is the determination of the exchange parity important?
Study smarter with the SolutionInn App