Question Description
Consider a LIBRARY database which is used to keep track of books, borrowers, and bookloans. The relational schema is depicted below.2. Try to convert this into a conceptual schema (ER diagram):a. Recall that each table may have come from an entity, a relationship, a weak entity,or a multivalued attribute. Try to figure out which is which.b. Write down any assumptions you make.c. Draw the ER diagram using ERDPlus.3. This process is called “reverse engineering” because you are taking an existing databaseand trying to figure out the thought process behind it.4. Compare your answer with a neighbor. Discuss the assumptions you made.Task 2: Data5. Download the “sakila-reduced.pdf” database from Canvas.6. Reverse engineer this database:a. Figure out what the primary keys are.b. Figure out what the foreign keys are.c. Construct the relational schema for this database. For each table, list the attributes.Indicate all primary keys (underlined) and all foreign keys (arrows). You can dothis in ERDPlus if you want.d. Draw an ER diagram of a conceptual schema for this database.7. Show the result to the instructor.8. Export an image of the ER diagram, and upload it to Canvas under Lab 3.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.