Question: I need a solution for this. create an ERD.. also create database. m project lves, and Scott Incorporated is an agency that specializes in representing

I need a solution for this. create an ERD.. also create database.
m project lves, and Scott Incorporated is an agency that specializes in representing clients in the fields of sport nment. Given the nature of the business, some employees are given a company car to drive, and each y car must be assigned to an employee. Each employee has a unique employee number, plus an addre ertifications. Not all employees have earned one or more certifications. Company cars are identified b id, and also contain a license plate number, make, model, and year. Employees represent clients. Not a ployee. Sometimes clients refer one another to use Adams, Ives, and Scott to represent them. A given r one or more other clients. A client may or may not have been referred to Adams, Ives, and Scott by a ut a client may be referred by only one other client. Each client is assigned a unique client number. Adc s recorded for each client are name, address, and date of birth. ing the entities, then their relationships, and finally add the attributes to each te an ERD by first id te a database and add the tables to the database. including ERD diagram using Open ModelSphere or Dia. m project lves, and Scott Incorporated is an agency that specializes in representing clients in the fields of sport nment. Given the nature of the business, some employees are given a company car to drive, and each y car must be assigned to an employee. Each employee has a unique employee number, plus an addre ertifications. Not all employees have earned one or more certifications. Company cars are identified b id, and also contain a license plate number, make, model, and year. Employees represent clients. Not a ployee. Sometimes clients refer one another to use Adams, Ives, and Scott to represent them. A given r one or more other clients. A client may or may not have been referred to Adams, Ives, and Scott by a ut a client may be referred by only one other client. Each client is assigned a unique client number. Adc s recorded for each client are name, address, and date of birth. ing the entities, then their relationships, and finally add the attributes to each te an ERD by first id te a database and add the tables to the database. including ERD diagram using Open ModelSphere or Dia
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
