Chapter 5.8, Problem 5ARQ

Explanation of Solution

Criticality of User involvement during database development:

• The database design that depends completely on user views their business environment.
• For example, consider “Student”database, contains a list of possible data such as “Classes”, “Students”, “Grades”, “Office_Visits”, “Emails”, “Majors”, “Student_Organization”, “Advisor”.
• The possibilities of the including the data list will be a major concern for the user considering which data to be included and what data should be excluded based on the requirement in performing the required process.
• The above mentioned list may extend further, but it should include all the necessary data that user want to perform their jobs.

Function of a data models:

The functions of a Data model are:

• Data
• Relationships

Data:

• Data is referred as the collection of information.
• It helps the user for tracking something in database, is also referred as entity.

Relationship:

• Entities have relationships among each other.
• For example, in student database, a Student has a relationship to Grades and Student has a relationship to Emails.

Database development process:

Definitions:

E-R model:

• ER model is a tool for creating data model.
• It is used for developers to describe the content of data model by using two functions called entities and relationships.

Entity:

• Entity helps the user for tracking something in database.
• Example entities in student database system are Student, Grade, Course, etc.

Relationships:

• Entities have relationships among each other.
• For example, in student database, a Student has a relationship to Major and Student has a relationship to Advisor.

Attribute:

• Attribute used to describe the entity characteristics...