2. Al Bayan Mineral Water Company has many workers. WORKER is identified by Worker ID and other details such as Name (which is composed of FirstName, MidName and Last name), Birth Date, Address, WorkCategory and Age (which is calculated from BirthDate). Based on the responsibilities WORKERS are classified into different work partition entities, they are INSPECTOR which is a separate sub entity of super entity WORKER, the other sub entities such as CONSULTANT and MEDICO are grouped sub entities which are mutually exclusive or disjoint. The respective individual attributes are defined as CONSULTANT has ConsultantLevel and MEDICO has MedicoClass. Dr an Enhanced Entity Relationship (EER) Diagram for the above scenario, Identify entities, attributes, subsets, disjoint entities, keys and generalization/specialization abstraction constraints if any.

2. Al Bayan Mineral Water Company has many workers. WORKER is identified by Worker ID and other details such as Name (which is composed of FirstName, MidName and Last name), Birth Date, Address, WorkCategory and Age (which is calculated from BirthDate). Based on the responsibilities WORKERS are classified into different work partition entities, they are INSPECTOR which is a separate sub entity of super entity WORKER, the other sub entities such as CONSULTANT and MEDICO are grouped sub entities which are mutually exclusive or disjoint. The respective individual attributes are defined as CONSULTANT has ConsultantLevel and MEDICO has MedicoClass. Dr an Enhanced Entity Relationship (EER) Diagram for the above scenario, Identify entities, attributes, subsets, disjoint entities, keys and generalization/specialization abstraction constraints if any.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Use the ER Diagram shown on Figure 1 to answer question 9: 9. According to the ER diagram on Figure 1, which of the following is true? A) For each employee, we will keep track of either the employee name or the unique employee ID. B) For each department, we will keep track of either the unique department ID or the department location. C) Each employee reports to exactly one department. A department may have many employees reporting to it, but it does not have to have any. D) None of the above. Answer: EmpID EmpName EMPLOYEE Reports To Figure 1 DeptID DeptLocation DEPARTMENT
Given the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salim Housni 2000 200-B Salim Housni 2000 200-C Salim Housni 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE ProjectID --> EmployeeName (....) ProjectID --> EmployeeSalary (....) ProjectID , EmployeeName -->EmployeeSalary (....) EmployeeName --> EmployeeSalary (....) EmployeeSalary --> ProjectID (....) EmployeeSalary --> EmployeeName , ProjectID (....)
What is the cardinality for the entity Department in the following ERD? Employee Department Employee number First name Last name Job title Dept number Dept number works Dept name in Dept location Instruction: Use proper spelling and/or punctuation in your answer.
Please include the eer diagram
Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…
When must a many-to-many relationship bemodeled as an associative entity
Draw the Enhanced Entity–Relationship (EER) model and the relational schema for the case study below: This case study describes a company called HomeCinema, which rents out videos to its members. The first branch of HomeCinema was established in 1982 in Jeddah but the company has now grown and has many branches throughout the country. As HomeCinema has grown, so has the difficulties in managing the increasing amount of data used and generated by the company. To ensure the continued success of the company, the Director of HomeCinema has urgently requested that a database application be built to help solve the increasing problems of data management. The data held on a branch of HomeCinema is the branch address made up of street, city, state, and zip code, and the telephone numbers (maximum of 3 lines). Each branch is given a branch number, which is unique throughout the company. Each branch of HomeCinema has staff, which includes a Manager, one or more Supervisors, and a number of other…
1. Draw a data model for the following entities, considering the entities as representing a system for a patient billing system and including only the attributes that would be appropriate for this context: • Patient (age, name, hobbies, blood type, occupation, insurance carrier, address, phone). Insurance carrier (name, number of patients on plan, address, contact name, phone). Doctor (specialty, provider identification number, golf handicap, age, phone, name)
Draw an E-R diagram based on the following relational design.SeniorTeachers(teacherId, name, dept, division)TeachingAssistants(teacherId, name, dept, division).# These can be currently registered students who are employed part-time as teaching assistants,# or they can be PhD students who are employed full-time.Programmes(programmeCode, programmeName, dept, director)director → SeniorTeachers.teacherIdCourses(courseCode, courseName, credits, level, dept, division, ownedBy)ownedBy → Programmes.programmeCode# level is one of “first cycle” or “second cycle”.programmeCourses(programme, academicYear, studyYear, course, courseType)programme→ Programmes.programmeCodecourse → Courses.courseCode# studyYear is “1” or “2” for Master’s programmes and “1”, “2” or “3” for Bachelor’s programmes.# courseType is one of: “compulsory”, “compulsory-elective” or “elective”.# Programmes can include different courses in different academic years.# The same course could have a different courseType in different…