Refining the ER Design for the COMPANY Database



Rating - 3/5
473 views

We can now refine the database design in Figure 7.8 by changing the attributes that represent relationships into relationship types. The cardinality ratio and participation constraint of each relationship type are determined from the requirements listed in Section 7.2. If some cardinality ratio or dependency cannot be determined from the requirements, the users must be questioned further to determine these structural constraints. In our example, we specify the following relationship types:

These Topics Are Also In Your Syllabus Refining the ER Design for the COMPANY Database
1 Types of Operating Systems - Batch operating system, Time-sharing systems, Distributed OS, Network OS, Real Time OS link
2 Relationship Types, Relationship Sets, Roles, and Structural Constraints link
You May Find Something Very Interesting Here. Refining the ER Design for the COMPANY Database link
3 Attribute Specification in Select Clause link
4 Weak Entity Types link
5 Types Of Systems link

? MANAGES, a 1:1 relationship type between EMPLOYEE and DEPARTMENT. EMPLOYEE participation is partial. DEPARTMENT participation is not clear from the requirements. We question the users, who say that a department must have a manager at all times, which implies total participation.13 The attribute Start_date is assigned to this relationship type.

These Topics Are Also In Your Syllabus Refining the ER Design for the COMPANY Database
1 Types of Operating Systems - Batch operating system, Time-sharing systems, Distributed OS, Network OS, Real Time OS link
2 Database Architecture link
You May Find Something Very Interesting Here. Refining the ER Design for the COMPANY Database link
3 Data Mining and Information Retrieval link
4 Specialty Databases link
5 Database Users and Administrators link

? WORKS_FOR, a 1:N relationship type between DEPARTMENT and EMPLOYEE. Both participations are total.

These Topics Are Also In Your Syllabus Refining the ER Design for the COMPANY Database
1 Types of Operating Systems - Batch operating system, Time-sharing systems, Distributed OS, Network OS, Real Time OS link
2 Constraints and Characteristics of Specialization and Generalization Hierarchies link
You May Find Something Very Interesting Here. Refining the ER Design for the COMPANY Database link
3 Modeling of UNION Types Using Categories link
4 A Sample UNIVERSITY EER Schema, Design Choices, and Formal Definitions link
5 Example of Other Notation: Representing Specialization and Generalization in UML Class Diagrams link

? CONTROLS, a 1:N relationship type between DEPARTMENT and PROJECT. The participation of PROJECT is total, whereas that of DEPARTMENT is determined to be partial, after consultation with the users indicates that some departments may control no projects.

These Topics Are Also In Your Syllabus Refining the ER Design for the COMPANY Database
1 Types of Operating Systems - Batch operating system, Time-sharing systems, Distributed OS, Network OS, Real Time OS link
2 Entity Types, Entity Sets, Keys, and Value Sets-2 link
You May Find Something Very Interesting Here. Refining the ER Design for the COMPANY Database link
3 Initial Conceptual Design of the COMPANY Database link
4 Relationship Types, Relationship Sets, Roles, and Structural Constraints link
5 Types Of Systems link

? SUPERVISION, a 1:N relationship type between EMPLOYEE (in the supervisor role) and EMPLOYEE (in the supervisee role). Both participations are determined to be partial, after the users indicate that not every employee is a supervisor and not every employee has a supervisor.

These Topics Are Also In Your Syllabus Refining the ER Design for the COMPANY Database
1 Types of Operating Systems - Batch operating system, Time-sharing systems, Distributed OS, Network OS, Real Time OS link
2 Introduction to Database Security Issues link
You May Find Something Very Interesting Here. Refining the ER Design for the COMPANY Database link
3 Discretionary Access Control Based on Granting and Revoking Privileges link
4 Introduction to Database Security Issues link
5 Types Of Systems link

? WORKS_ON, determined to be an M:N relationship type with attribute Hours, after the users indicate that a project can have several employees working on it. Both participations are determined to be total.

? DEPENDENTS_OF, a 1:N relationship type between EMPLOYEE and DEPENDENT, which is also the identifying relationship for the weak entitytype DEPENDENT. The participation of EMPLOYEE is partial, whereas that of DEPENDENT is total.

After specifying the above six relationship types, we remove from the entity types in Figure 7.8 all attributes that have been refined into relationships. These include Manager and Manager_start_date from DEPARTMENT; Controlling_department from PROJECT; Department, Supervisor, and Works_on from EMPLOYEE; and Employee from DEPENDENT. It is important to have the least possible redundancy when we design the conceptual schema of a database. If some redundancy is desired at the storage level or at the user view level, it can be introduced later.


Rating - 3/5
524 views

Advertisements