Create the ERD. (Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT. Similarly, you will discover that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, etc.)
Answer to relevant QuestionsCreate the relational diagram.For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write none in the space provided.Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?What two attributes must be contained in the composite entity between STORE and PRODUCT? Use proper terminology in your answer.Create an ERD based on the Crow’s Foot model, using the following requirements:An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales ...
Post your question