Identify each relationship type and write all of the business rules.
Answer to relevant QuestionsWhat does it mean to say that a database displays both entity integrity and referential integrity?Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate the difference between a natural join, an equijoin, and an outerjoin.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).Using the tables in Figure Q3.11, create the table that results from MACHINE DIFFERENCE BOOTH.MACHINE_PRODUCT MACHINE_PRICEChips ............. 1.25Chocolate Bar ........... 1For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided.
Post your question