Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design EERD modeling that applies the following constraints, A relational database is to be designed for a large sized Car manufacturing and rental Company. The

Design EERD modeling that applies the following constraints, A relational database is to be designed for a large sized Car manufacturing and rental Company. The information required includes a description of cars, customers, company employees. The company employees could be described by such data as , Employee name , ssn , address, phone and their job type. There are three types of employees there, sales person who buy or sells cars with customers, mechanic who responsible of car maintenance tasks and the traditional employee who responsible on day to day activates. The DB should register the available worked hours for each sales person and his experience grade, also the mechanic we want to keep tack data about his technical grade. Cars are to be described by such data as: make, model, year of production, engine size, fuel type, number of passengers, registration number, purchase price, purchase date, and price. Each client has specific name and ID number and keep data about his phone, and address. All major repairs and maintenance tasks are done by company Mechanic and should be registered job repair file that contains data about job description, car number, and the repairing cost which may be cost for new part or cost for maintenance only.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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_2

Step: 3

blur-text-image_3

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

Database Systems For Advanced Applications 15th International Conference Dasfaa 2010 Tsukuba Japan April 2010 Proceedings Part 1 Lncs 5981

Authors: Hiroyuki Kitagawa ,Yoshiharu Ishikawa ,Wenjie Li ,Chiemi Watanabe

2010th Edition

3642120253, 978-3642120251

More Books

Students also viewed these Databases questions

Question

Calculate the iterated integral. S S (4x 9xy) dy dx

Answered: 1 week ago