Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Create an ERD and Data Dictionary for the following example

Create an ERD and Data Dictionary for the following example

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter9: Joining Data From Multiple Tables
Section: Chapter Questions
Problem 10HOA: An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a...
See similar textbooks
icon
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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Database Functions
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
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS