Given the following business scenarios, create Crow’s Foot ERDs using a specialization hierarchy if appropriate. (Make...
Given the following business scenarios, create Crow’s Foot ERDs using a specialization hierarchy if appropriate. (Make sure that you diagram parent-childrelationships.)Two-Bit Drilling Company keeps information on employees and their dependents. Each employee has an employee number, name, date of hire, and title. If an employee is aninspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the SSN and departmentnames should be kept. All dependents must be...
Two-Bit Drilling Company keeps information on employees and their dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the SSN and department names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many...
Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others...
Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If anemployee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, theSocialSecurity number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, whileothers will have many dependents.
2. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s name and date of birth are recorded. Some patients are resident patients who spend at least one night in the hospital, and others are outpatients who are treated and released. Resident patients are assigned a room. Each room is identified by...
Create a crows foot erd using a specialization hierarchy if appropriate. Granite sales company keeps information on its employees and the departments in which they work. For each department, the department name,internal mailbox server, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried, hourly, or work on contract. All employees are assigned an employee number, which is kept along with the employee's name...
Problem 3. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This...
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Granite Sales Company keeps information on employeesand the department that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can havemany assigned employees, and each employee is assigned to only one department. Employees can salaried employees, hourly employees, or contract employees. All employeesare assigned an employee number. This is kept along with...