Given the sample records in the CHARTER table shown in Table P5.1, write the relational schema and draw the dependency diagram for the table structure. Make sure that you label all dependencies.(Will provide chart)
Decompose the dependency diagram in Problem 1 to create table structures that are all in 3NF and write the relational schema. Make sure that you label all dependencies.
Draw the Crow’s Foot ERD to reflect the properly decomposed dependency diagrams you created in Problem 2. Make sure that the ERD yields a database that can track all of the data shown in Problem 1. Show all entities, relationships, connections, optionalities, and cardinalities
Modify the data model to incorporate the additional attributes specified above. In modifying data model take the business rules above into consideration. Add extra attributes if necessary. Pay special attention to selection of primary and foreign keys. Explain your use of primary and foreign keys.
Đã trao cho:
18 freelancer đang chào giá trung bình $34 cho công việc này
Hi, We are Oracle certified, highly qualified and well experienced db design & administration professionals. We have done lot of similar designs and can fulfill your requirement at ease.