Answered: Create an ERD and Data Dictionary for…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Create an ERD and Data Dictionary for the following example. Use draw.io and submit a PDF of your ERD.

Several apartment buildings are managed by the same company. Our database will store data about the buildings, apartments, renters, and rentals. Assume that only one renter is listed on each rental at a time. We do not need to store data about the management company. Use the attributes listed below and create a 3NF database.

Buildingid

Building_name

Building_address

Building_City

Building_State

Building_ZipCode

Building_manager_name

Building_phone_number

ApartmentID

Apartment_Number

Apartment_Bathroom_Count

Apartment_Bedroom_Count

RentalID

Rental_Start_Date

Rental_End_Date

Rent_Amount

RenterID

Renter_First_Name

Renter_Last_Name

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions