CMPSC 321 Relational Database Theory and Design Lab 2 - Part 1: Relational Schemas Task 1: Relational schema 1. Consider a MOVIE database in which data is recorded about the movie industry. The ER diagram is below (it is not quite the same as the one from the last lab) Name BirthDate Name Address (D) Role PRODUCTION COMPANY PERSON Acts in Directs MOVIE Produces ID) Genre Title Year 2. 3. 4. 5. Map this ER diagram to a relational schema using the techniques discussed in class. Use ERDPlus to draw the relational schema. Specify all primary keys and foreign keys. Compare your schema with a neighbor's. Decide together what seems correct. Show the result to the instructor before proceeding. Task 2: Data Now, for each relation in your schema, create a table in Excel or Word. (We'll use a real database program such as Access later.) Attributes go across, at the top of columns. You can put each table on its own tab in Excel or just put them all on one sheet. Make the column headings bold so they stand out. Fill in the database with some values: Think of a movie. Fill in its information, with a few of the actors. Get another movie from someone else in the class and fill in that informatiorn too 6. 7. 8. Make sure all entity integrity constraints and referential integrity constraints are met. 9. Show the result to the instructor before proceeding. 10. Upload your document to Canvas under Lab 2