There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called

Quiz questions on E-R model, E-R design, constraints, atomic domains and querying databases like DDL and DML. Database implementation is the process of: installing database software, performing configuration and customization, running and testing the database, integrating it with applications, and training the users.  Some critical points to keep in mind for a good database design include: Maintaining data consistency and integrity, Low redundancy, Faster searching through indices, Security measures, and Storing data in fragmented bits of information.  The steps in database design... Show more

Quiz questions on E-R model, E-R design, constraints, atomic domains and querying databases like DDL and DML.

Database implementation is the process of: installing database software, performing configuration and customization, running and testing the database, integrating it with applications, and training the users. 

Some critical points to keep in mind for a good database design include: Maintaining data consistency and integrity, Low redundancy, Faster searching through indices, Security measures, and Storing data in fragmented bits of information. 

The steps in database design are:
Gather business requirements
Understand business roadmap
Identify entities and attributes
Identify relationships
Create a logical ER diagram
Validate the logical ER diagram 

The four phases that create database design are: Conceptual design, Logical design, Normalization, and Physical design. 
A good database design is essential for a strong database management system (DBMS). It provides the basis for: Data governance, Data storage, and Data retrieval. 

Show less