Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design a database to hold the contractual data of a rental company. Every contract covers the following: data about the client (client number, name and

Design a database to hold the contractual data of a rental company. Every contract covers the following: 

  1. data about the client (client number, name and phone); 
  2. data about the property (property number, address, and owner);
  3.  parameters of the contract: period - dates of start and end, and the amount the clients pays. 
  4. Owner is described by owner number, name, and phone. 

Notes:

  1.  one client may rent several properties;
  2.  one owner may own several properties. 

Design outcomes are ER model and database relational schema normalized to 3NF/BCNF.

Step by Step Solution

3.40 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

To design a database to hold the contractual data of a rental company we can start by creating an EntityRelationship ER model and then proceed to crea... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Java Programming

Authors: Joyce Farrell

9th edition

1337397075, 978-1337397070

Students also viewed these Programming questions