Home » Uncategorized » Relational Database

No More Worries!

image Our orders are delivered strictly on time without delay

Paper Formatting

  • Double or single-spaced
  • 1-inch margin
  • 12 Font Arial or Times New Roman
  • 300 words per page

Our Guarantees

image

  • Free Unlimited revisions
  • Guaranteed Privacy
  • Money Return guarantee
  • Plagiarism Free Writing

Coupon Code

Relational Database

Paper , Order, or Assignment Requirements

Consider a LIBRARY database which is used to keep track of books, borrowers, and book loans. 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 database and trying to figure out the thought process behind it. 4. Compare your answer with a neighbor. Discuss the assumptions you made. Task 2: Data 5. 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 do this 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.

findout

Follow Us

Facebook
Twitter
Google+

Free Price Quote

Subject:
Type:
Pages/Words:
Single spaced
approx 275 words per page
Urgency:
Level:
Currency:
Total Cost:

Why Choose Us

image

  • Money Return guarantee
  • Guaranteed Privacy
  • Written by Professionals
  • Paper Written from Scratch
  • Timely Deliveries
  • Free Amendments