Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Best Software is an company that specializes selling software and in helping clients who bought software form them. They provide free support to the

The Best Software is an company that specializes selling software and in helping clients who bought software form them. They provide free support to the corporate clients who bought software with long term license agreement. The client is the person in the company that uses The Best Software products. Given the nature of the business, some The Best Software employees are given a company car to drive, and each The Best Software company car must be assigned to an employee. Each employee has a unique employee number, plus an address and set of certifications. Not all employees have earned one or more certifications. Company cars are identified by their vehicle id, and also contain a license plate number, make, model, and year. Employees represent clients for their account. Not all employees represent clients, while some employees represent many clients. Each client is represented by one and only one employee. Sometimes clients refer one another to use to the Best Software. A given client can refer one or more other clients. Each client is assigned a unique client number. Additional attributes recorded for each client are; name of the person, company name, company address, and phone number and email.

Q.

Develop and design Presentation Layer ER diagram based on Chens Model. Decide and show the related attributes based on given parameters on the ER diagram. For each Entity, identify the primary key as well.

Once you define the entities, then draw Presentation Layer ER diagram that shows the entity types and relationship types. Explain the relationship among the entities. While you must name each relationship type and define its structural constraints, it is not necessary that you supply role names. Provide our solution in ER diagrams

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

Conceptual Database Design An Entity Relationship Approach

Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe

1st Edition

0805302441, 978-0805302448

More Books

Students also viewed these Databases questions