database design
$30-35 AUD
Paid on delivery
Assignment:
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.
Project ID: #1047404
About the project
Awarded to:
16 freelancers are bidding on average $34 for this job
SQL EXPERT here ! I think you have referenced to some document but there is no document attached ! Please provide the document !
Having very good exp. in db design, if you provide complete information will do it. Looking for business relattion.
I Have an experience of database designing in oracle and sqlserver as well. I can do this work in a good manner and on time. If there is any document than please send that to me for better understanding, hopi More
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.
