Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started