Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

drawing by use EER diagram 1. A company has a unique Company Id and Contact No (a company can have one or more contact number).

image text in transcribed
drawing by use EER diagram
1. A company has a unique Company Id and Contact No (a company can have one or more contact number). The company is broadly classified in to Consultancy services and Logistic services. Consultancy services recorded its Service ld. Similarly, Logistic services is recorded its Service type. Consultancy services cannot be serviced as Logistic. There are different type of Consultancy services some of them are Real State Consultancy and Legal Consultancy. Real State Consultancy recorded its Location. Legal Consultancy recorded its Advisor Id. Sometimes Real Consultancy can be serviced as Legal Consultancy. A company owned by one or more Owner also an owner can owned one or more companies. An Owner has an identifier Owner Id. Analyze the scenario and construct EER-Diagram, include participation constraint and disjoint or overlap constraint 2. Analyze the following scenario and construct EER-Diagram by including participation constraint and disjoint or overall constraint. We want to create a database for a Nissan company that have customer who purchase Car. For this, we must store data about Customer and Car. Car has carno as an identifier. Company store customer details customerid (identifier) and Cname. Customer can purchase one more car but car will be purchased by exactly customer. All the types of Customers are broadly classified into two, they are Full paymentCustomer and LoanCustomer. FullpaymentCustomer cannot purchase a car as LoanCust. The LoanAmount is recorded in the Loan Customer while Totalpayment is recorded in the FullpaymentCustomer. There are different types in LoanCustomer some of them are FullLoan and HalfLoan. FullLoan can be recorded with amount. Sometimes HalfLoan are using as FullLoan. HalfLoan are recorded with Down Payment

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

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

PC Magazine Guide To Client Server Databases

Authors: Joe Salemi

1st Edition

156276070X, 978-1562760700

More Books

Students also viewed these Databases questions

Question

3. Evaluate a Web-based training site.

Answered: 1 week ago