Help In Database:

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 ID Role COMPANY PERSON Acts in Directs MOVIE Produces Genre Title Year 2. Map this ER diagram to a relational schema using the techniques discussed in class. Use ERDPlus to draw the relational schema. 3. Specify all primary keys and foreign keys. 4. Compare your schema with a neighbor's. Decide together what seems correct. 5. Show the result to the instructor before proceeding. Task 2: Data 6. 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 information too. 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. Some tasks are adapted from exercises in Elmasri and Navathe's Fundamentals of Database Systems, 6th edition, Addison Wesley, 2011, pp. 299-300