Create the basic Crow’s Foot ERD for DealCo.
Answer to relevant QuestionsTypically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between PATIENT and ...Write the business rules that are reflected in the ERD shown in Figure (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always ...Explain why the data dictionary is sometimes called "the database designer's database."Identify and describe the components of the table shown in Figure Q3.17, using correct terminology. Use your knowledge of naming conventions to identify the table’s probable foreignkey(s).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.
Post your question