Draw an entity-relationship diagram that shows the relationships among a database , database applications, and users.

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 5, Problem 5.1UYK

Draw an entity-relationship diagram that shows the relationships among a database, database applications, and users.

Expert Solution & Answer

Program Plan Intro

E-R model:

It 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:

It 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:

It used to describe the entity characteristics.
Example attributes of student entity is Student_id, Student_name, Student_address, etc.

Identifier:

It is an attribute or group of attribute, but its value is related with one and only one entity instance.

Example of E-R diagram:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 1

Explanation of Solution

Entity Relationship diagram that displays relationship among the database, database application and users:

The below is the E-R diagram that shows the relationship that is laid among the database, database application and users:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 2

User:

The person or end user that can process the application that is stored in the database.

Database application:

A database application is a collection of four elements namely forms, reports, queries and application which acts as an intermediate between the user and data of the database

Database:

Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.

Explanation of the E-R diagram:

Many user can use the database application.
- Example of the user entity could be “students”, “faculty”.
Many database applications can be present in a single database.
- Example of the database application could be “Bookstore”,”Library”.
Only one database can contain many database application.
- Example of the database could be “studentDB”,”BookStoreDB”.
The relationship between the user and the database application is “M:N (Many to many )relationship.
The relationship between the database application and theDatbase is “N:1”(Many to One) relationship.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Write the SQL code that permits to implement the tables: Student and Transcript. NB: Add the constraints on the attributes – keys and other.

Draw an ERD that will involve the entity types: Professor, Student, Department and Course. Be sure to add relationship types, key attributes, attributes and multiplicity on the ERD.

Draw an ERD that represents a book in a library system. Be sure to add relationship types, key attributes, attributes and multiplicity on the ERD.

Answer 2

Textbook Question

Chapter 5, Problem 5.1UYK

Draw an entity-relationship diagram that shows the relationships among a database, database applications, and users.

Expert Solution & Answer

Program Plan Intro

E-R model:

It 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:

It 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:

It used to describe the entity characteristics.
Example attributes of student entity is Student_id, Student_name, Student_address, etc.

Identifier:

It is an attribute or group of attribute, but its value is related with one and only one entity instance.

Example of E-R diagram:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 1

Explanation of Solution

Entity Relationship diagram that displays relationship among the database, database application and users:

The below is the E-R diagram that shows the relationship that is laid among the database, database application and users:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 2

User:

The person or end user that can process the application that is stored in the database.

Database application:

A database application is a collection of four elements namely forms, reports, queries and application which acts as an intermediate between the user and data of the database

Database:

Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.

Explanation of the E-R diagram:

Many user can use the database application.
- Example of the user entity could be “students”, “faculty”.
Many database applications can be present in a single database.
- Example of the database application could be “Bookstore”,”Library”.
Only one database can contain many database application.
- Example of the database could be “studentDB”,”BookStoreDB”.
The relationship between the user and the database application is “M:N (Many to many )relationship.
The relationship between the database application and theDatbase is “N:1”(Many to One) relationship.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Textbook Question

Chapter 5, Problem 5.1UYK

Draw an entity-relationship diagram that shows the relationships among a database, database applications, and users.

Expert Solution & Answer

Program Plan Intro

E-R model:

It 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:

It 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:

It used to describe the entity characteristics.
Example attributes of student entity is Student_id, Student_name, Student_address, etc.

Identifier:

It is an attribute or group of attribute, but its value is related with one and only one entity instance.

Example of E-R diagram:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 1

Explanation of Solution

Entity Relationship diagram that displays relationship among the database, database application and users:

The below is the E-R diagram that shows the relationship that is laid among the database, database application and users:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 2

User:

The person or end user that can process the application that is stored in the database.

Database application:

A database application is a collection of four elements namely forms, reports, queries and application which acts as an intermediate between the user and data of the database

Database:

Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.

Explanation of the E-R diagram:

Many user can use the database application.
- Example of the user entity could be “students”, “faculty”.
Many database applications can be present in a single database.
- Example of the database application could be “Bookstore”,”Library”.
Only one database can contain many database application.
- Example of the database could be “studentDB”,”BookStoreDB”.
The relationship between the user and the database application is “M:N (Many to many )relationship.
The relationship between the database application and theDatbase is “N:1”(Many to One) relationship.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 5, Problem 5.1UYK

Draw an entity-relationship diagram that shows the relationships among a database, database applications, and users.

Expert Solution & Answer

Program Plan Intro

E-R model:

It 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:

It 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:

It used to describe the entity characteristics.
Example attributes of student entity is Student_id, Student_name, Student_address, etc.

Identifier:

It is an attribute or group of attribute, but its value is related with one and only one entity instance.

Example of E-R diagram:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 1

Explanation of Solution

Entity Relationship diagram that displays relationship among the database, database application and users:

The below is the E-R diagram that shows the relationship that is laid among the database, database application and users:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 2

User:

The person or end user that can process the application that is stored in the database.

Database application:

A database application is a collection of four elements namely forms, reports, queries and application which acts as an intermediate between the user and data of the database

Database:

Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.

Explanation of the E-R diagram:

Many user can use the database application.
- Example of the user entity could be “students”, “faculty”.
Many database applications can be present in a single database.
- Example of the database application could be “Bookstore”,”Library”.
Only one database can contain many database application.
- Example of the database could be “studentDB”,”BookStoreDB”.
The relationship between the user and the database application is “M:N (Many to many )relationship.
The relationship between the database application and theDatbase is “N:1”(Many to One) relationship.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

Expert Solution & Answer

Program Plan Intro

E-R model:

It 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:

It 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:

It used to describe the entity characteristics.
Example attributes of student entity is Student_id, Student_name, Student_address, etc.

Identifier:

It is an attribute or group of attribute, but its value is related with one and only one entity instance.

Example of E-R diagram:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 1

Explanation of Solution

Entity Relationship diagram that displays relationship among the database, database application and users:

The below is the E-R diagram that shows the relationship that is laid among the database, database application and users:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 2

User:

The person or end user that can process the application that is stored in the database.

Database application:

A database application is a collection of four elements namely forms, reports, queries and application which acts as an intermediate between the user and data of the database

Database:

Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.

Explanation of the E-R diagram:

Many user can use the database application.
- Example of the user entity could be “students”, “faculty”.
Many database applications can be present in a single database.
- Example of the database application could be “Bookstore”,”Library”.
Only one database can contain many database application.
- Example of the database could be “studentDB”,”BookStoreDB”.
The relationship between the user and the database application is “M:N (Many to many )relationship.
The relationship between the database application and theDatbase is “N:1”(Many to One) relationship.

Answer 8

Expert Solution & Answer

Program Plan Intro

E-R model:

It 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:

It 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:

It used to describe the entity characteristics.
Example attributes of student entity is Student_id, Student_name, Student_address, etc.

Identifier:

It is an attribute or group of attribute, but its value is related with one and only one entity instance.

Example of E-R diagram:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 1

Explanation of Solution

Entity Relationship diagram that displays relationship among the database, database application and users:

The below is the E-R diagram that shows the relationship that is laid among the database, database application and users:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 2

User:

The person or end user that can process the application that is stored in the database.

Database application:

A database application is a collection of four elements namely forms, reports, queries and application which acts as an intermediate between the user and data of the database

Database:

Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.

Explanation of the E-R diagram:

Many user can use the database application.
- Example of the user entity could be “students”, “faculty”.
Many database applications can be present in a single database.
- Example of the database application could be “Bookstore”,”Library”.
Only one database can contain many database application.
- Example of the database could be “studentDB”,”BookStoreDB”.
The relationship between the user and the database application is “M:N (Many to many )relationship.
The relationship between the database application and theDatbase is “N:1”(Many to One) relationship.

Answer 9

Expert Solution & Answer

Answer 10

Expert Solution & Answer

Answer 11

Program Plan Intro

E-R model:

It 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:

It 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:

It used to describe the entity characteristics.
Example attributes of student entity is Student_id, Student_name, Student_address, etc.

Identifier:

It is an attribute or group of attribute, but its value is related with one and only one entity instance.

Example of E-R diagram:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 1

Answer 12

Explanation of Solution

Entity Relationship diagram that displays relationship among the database, database application and users:

The below is the E-R diagram that shows the relationship that is laid among the database, database application and users:

Using MIS (10th Edition), Chapter 5, Problem 5.1UYK , additional homework tip 2

User:

The person or end user that can process the application that is stored in the database.

Database application:

A database application is a collection of four elements namely forms, reports, queries and application which acts as an intermediate between the user and data of the database

Database:

Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.

Explanation of the E-R diagram:

Many user can use the database application.
- Example of the user entity could be “students”, “faculty”.
Many database applications can be present in a single database.
- Example of the database application could be “Bookstore”,”Library”.
Only one database can contain many database application.
- Example of the database could be “studentDB”,”BookStoreDB”.
The relationship between the user and the database application is “M:N (Many to many )relationship.
The relationship between the database application and theDatbase is “N:1”(Many to One) relationship.

Answer 13

Ch. 5.2 - Prob. 1EGDQ Ch. 5.2 - Prob. 2EGDQ Ch. 5.2 - Prob. 3EGDQ Ch. 5.2 - Prob. 4EGDQ Ch. 5.2 - Prob. 5EGDQ Ch. 5.2 - Prob. 6EGDQ Ch. 5.2 - Prob. 7EGDQ Ch. 5.2 - Consider the adage Never ask a question for which...Ch. 5.3 - Prob. 1SAQ Ch. 5.3 - Prob. 2SAQ

Draw an entity-relationship diagram that shows the relationships among a database , database applications, and users.

Concept explainers

Videos

Explanation of Solution

Want to see more full solutions like this?

Chapter 5 Solutions