Define each of the following terms: entity type entity-relationship model entity instance Attribute relationship type strong entity type multivalued attribute associative entity cardinality constraint weak entity binary relationship derived attribute business rule

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 2, Problem 2.1RQ

Define each of the following terms:

entity type
entity-relationship model
entity instance
Attribute
relationship type
strong entity type
multivalued attribute
associative entity
cardinality constraint
weak entity
binary relationship
derived attribute
business rule

Expert Solution

Program Plan Intro

(a)

Definition of Entity type.

Explanation of Solution

Entity type can be defined as a set of entities which share some common characteristics, behavior and attributes.

Expert Solution

Program Plan Intro

(b)

Definition of Entity-relational model.

Explanation of Solution

Entity-relational model represents the logical relationship between the entities and attributes in the database for an organization. it helps in creating database easily and can be understood by all. E-R model can be expressed as entity-relationship diagram also called as (ERD diagram).

Expert Solution

Program Plan Intro

(c)

Definition of entity instance.

Explanation of Solution

Entity instance is single occurrence of entity type. Consider an example, suppose employee is an entity type which has many instances. Example of instances can be John, Jenny or any other employee.

Expert Solution

Program Plan Intro

(d)

Definition of attribute.

Explanation of Solution

Every entity instance or set has its own attributes. Attributes state the behavior and characteristics of the entity. consider an example of employee here employee is the entity set that consists of various attributes such as name, address, location, employee id, mobile number etc., which states the characteristics of the entity instance or set.

Expert Solution

Program Plan Intro

(e)

Definition of relationship type.

Explanation of Solution

Relationship type is the meaningful representation of data between the entity set. It is of four types:

i) one to one relationship: in this type of relationship, one record of the table is associated with one record of another table.

ii) one to many relationships: In this type of relationship, one record of first table can be associated with N numbers of records of the other table.

iii) many to one relationship: In this type of relationship, many or N number of records of the first table can be associated with one record of the other table.

iv) many to many relationshipsIn this type of relationship N number of records of first table can be associated with N numbers of records of the other table.

Expert Solution

Program Plan Intro

(f)

Definition of Strong entity type.

Explanation of Solution

Strong entity type: Strong entity is an entity which is not dependent on any other entity. For example, tire can be considered as an example of the strong entity as its existence does not depend on any vehicle entity set.

Expert Solution

Program Plan Intro

(g)

Definition of multi-valued attribute.

Explanation of Solution

Multivalued attributes are those which takes some values from the entity instance. For example, in the employee entity set address is a multi-value attribute it can hold the permanent and temporary address of the employee.

Expert Solution

Program Plan Intro

(h)

Definition of associative entity.

Explanation of Solution

Associative entity provides association between the given entity set or instance. An entity is associative only if it has all the entity set or instance involved in the many relationships. The result associative entity should be independent.

Expert Solution

Program Plan Intro

(i)

Definition of cardinality constraints.

Explanation of Solution

Cardinality constraints specify the number of elements associated with each other between the two tables. It can be of two types; minimum cardinality and maximum cardinality.

Expert Solution

Program Plan Intro

(j)

Definition of weak entity.

Explanation of Solution

Weak entity depends on another entity for its existence. And it has no importance or existence if the dependent entity does not exist. Example of weak entity can be room, as it depends on building and can exist only if there is any building.

Expert Solution

Program Plan Intro

(k)

Definition of Binary relationship.

Explanation of Solution

Binary relationship is used between the instances of two types and are among the most common types of relationship encountered. It supports three types of cardinalities:

i) one to one: consider an example of employee, each employee has its own parking area. Or we can say that the parking area is assigned to the employee.

ii) one to many: it indicates that one product is connected to others through a common product line.

iii) many to many: many students can do many courses and vice versa.

Expert Solution

Program Plan Intro

(l)

Definition of Derived attribute.

Explanation of Solution

Derived attribute can be calculated by using the related attributes. Suppose we must find the tenure of an employee, to find age, we need the date of birth and the date of joining of the employee. Thus, tenure of an employee is a derived attribute.

Expert Solution

Program Plan Intro

(m)

Definition of business rule.

Explanation of Solution

Business rules are used to provide direction to business and help to lead the progress of the business project. Some business rules are important as they provide logical schema. Database designers need to follow the business rules during the development of the database as per the directions provided by the honor of code. These rules are also used for maintaining the integrity and accuracy of data.

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

A cylinder of diameter 10 cm rotates concentrically inside another hollow cylinder of inner diameter 10.1 cm. Both cylinders are 20 cm long and stand with their axis vertical. The annular space is filled with oil. If a torque of 100 kg cm is required to rotate the inner cylinder at 100 rpm, determine the viscosity of oil. Ans. μ= 29.82poise

Make the following game user friendly with GUI, with some simple graphics The following code works as this: The objective of the player is to escape from this labyrinth. The player starts at the bottom left corner of the labyrinth. He has to get to the top right corner of the labyrinth as fast he can, avoiding a meeting with the evil dragon. The player can move only in four directions: left, right, up or down. There are several escape paths in all labyrinths. The player’s character should be able to moved with the well known WASD keyboard buttons. If the dragon gets to a neighboring field of the player, then the player dies. Because it is dark in the labyrinth, the player can see only the neighboring fields at a distance of 3 units. Cell Class: public class Cell { private boolean isWall; public Cell(boolean isWall) { this.isWall = isWall; } public boolean isWall() { return isWall; } public void setWall(boolean isWall) { this.isWall = isWall; } @Override public String toString() {…

Please original work What are four of the goals of information lifecycle management think they are most important to data warehousing, Why do you feel this way, how dashboards can be used in the process, and provide a real life example for each. Please cite in text references and add weblinks

Answer 2

Textbook Question

Chapter 2, Problem 2.1RQ

Define each of the following terms:

entity type
entity-relationship model
entity instance
Attribute
relationship type
strong entity type
multivalued attribute
associative entity
cardinality constraint
weak entity
binary relationship
derived attribute
business rule

Expert Solution

Program Plan Intro

(a)

Definition of Entity type.

Explanation of Solution

Entity type can be defined as a set of entities which share some common characteristics, behavior and attributes.

Expert Solution

Program Plan Intro

(b)

Definition of Entity-relational model.

Explanation of Solution

Entity-relational model represents the logical relationship between the entities and attributes in the database for an organization. it helps in creating database easily and can be understood by all. E-R model can be expressed as entity-relationship diagram also called as (ERD diagram).

Expert Solution

Program Plan Intro

(c)

Definition of entity instance.

Explanation of Solution

Entity instance is single occurrence of entity type. Consider an example, suppose employee is an entity type which has many instances. Example of instances can be John, Jenny or any other employee.

Expert Solution

Program Plan Intro

(d)

Definition of attribute.

Explanation of Solution

Every entity instance or set has its own attributes. Attributes state the behavior and characteristics of the entity. consider an example of employee here employee is the entity set that consists of various attributes such as name, address, location, employee id, mobile number etc., which states the characteristics of the entity instance or set.

Expert Solution

Program Plan Intro

(e)

Definition of relationship type.

Explanation of Solution

Relationship type is the meaningful representation of data between the entity set. It is of four types:

i) one to one relationship: in this type of relationship, one record of the table is associated with one record of another table.

ii) one to many relationships: In this type of relationship, one record of first table can be associated with N numbers of records of the other table.

iii) many to one relationship: In this type of relationship, many or N number of records of the first table can be associated with one record of the other table.

iv) many to many relationshipsIn this type of relationship N number of records of first table can be associated with N numbers of records of the other table.

Expert Solution

Program Plan Intro

(f)

Definition of Strong entity type.

Explanation of Solution

Strong entity type: Strong entity is an entity which is not dependent on any other entity. For example, tire can be considered as an example of the strong entity as its existence does not depend on any vehicle entity set.

Expert Solution

Program Plan Intro

(g)

Definition of multi-valued attribute.

Explanation of Solution

Multivalued attributes are those which takes some values from the entity instance. For example, in the employee entity set address is a multi-value attribute it can hold the permanent and temporary address of the employee.

Expert Solution

Program Plan Intro

(h)

Definition of associative entity.

Explanation of Solution

Associative entity provides association between the given entity set or instance. An entity is associative only if it has all the entity set or instance involved in the many relationships. The result associative entity should be independent.

Expert Solution

Program Plan Intro

(i)

Definition of cardinality constraints.

Explanation of Solution

Cardinality constraints specify the number of elements associated with each other between the two tables. It can be of two types; minimum cardinality and maximum cardinality.

Expert Solution

Program Plan Intro

(j)

Definition of weak entity.

Explanation of Solution

Weak entity depends on another entity for its existence. And it has no importance or existence if the dependent entity does not exist. Example of weak entity can be room, as it depends on building and can exist only if there is any building.

Expert Solution

Program Plan Intro

(k)

Definition of Binary relationship.

Explanation of Solution

Binary relationship is used between the instances of two types and are among the most common types of relationship encountered. It supports three types of cardinalities:

i) one to one: consider an example of employee, each employee has its own parking area. Or we can say that the parking area is assigned to the employee.

ii) one to many: it indicates that one product is connected to others through a common product line.

iii) many to many: many students can do many courses and vice versa.

Expert Solution

Program Plan Intro

(l)

Definition of Derived attribute.

Explanation of Solution

Derived attribute can be calculated by using the related attributes. Suppose we must find the tenure of an employee, to find age, we need the date of birth and the date of joining of the employee. Thus, tenure of an employee is a derived attribute.

Expert Solution

Program Plan Intro

(m)

Definition of business rule.

Explanation of Solution

Business rules are used to provide direction to business and help to lead the progress of the business project. Some business rules are important as they provide logical schema. Database designers need to follow the business rules during the development of the database as per the directions provided by the honor of code. These rules are also used for maintaining the integrity and accuracy of data.

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 2, Problem 2.1RQ

Define each of the following terms:

entity type
entity-relationship model
entity instance
Attribute
relationship type
strong entity type
multivalued attribute
associative entity
cardinality constraint
weak entity
binary relationship
derived attribute
business rule

Expert Solution

Program Plan Intro

(a)

Definition of Entity type.

Explanation of Solution

Entity type can be defined as a set of entities which share some common characteristics, behavior and attributes.

Expert Solution

Program Plan Intro

(b)

Definition of Entity-relational model.

Explanation of Solution

Entity-relational model represents the logical relationship between the entities and attributes in the database for an organization. it helps in creating database easily and can be understood by all. E-R model can be expressed as entity-relationship diagram also called as (ERD diagram).

Expert Solution

Program Plan Intro

(c)

Definition of entity instance.

Explanation of Solution

Entity instance is single occurrence of entity type. Consider an example, suppose employee is an entity type which has many instances. Example of instances can be John, Jenny or any other employee.

Expert Solution

Program Plan Intro

(d)

Definition of attribute.

Explanation of Solution

Every entity instance or set has its own attributes. Attributes state the behavior and characteristics of the entity. consider an example of employee here employee is the entity set that consists of various attributes such as name, address, location, employee id, mobile number etc., which states the characteristics of the entity instance or set.

Expert Solution

Program Plan Intro

(e)

Definition of relationship type.

Explanation of Solution

Relationship type is the meaningful representation of data between the entity set. It is of four types:

i) one to one relationship: in this type of relationship, one record of the table is associated with one record of another table.

ii) one to many relationships: In this type of relationship, one record of first table can be associated with N numbers of records of the other table.

iii) many to one relationship: In this type of relationship, many or N number of records of the first table can be associated with one record of the other table.

iv) many to many relationshipsIn this type of relationship N number of records of first table can be associated with N numbers of records of the other table.

Expert Solution

Program Plan Intro

(f)

Definition of Strong entity type.

Explanation of Solution

Strong entity type: Strong entity is an entity which is not dependent on any other entity. For example, tire can be considered as an example of the strong entity as its existence does not depend on any vehicle entity set.

Expert Solution

Program Plan Intro

(g)

Definition of multi-valued attribute.

Explanation of Solution

Multivalued attributes are those which takes some values from the entity instance. For example, in the employee entity set address is a multi-value attribute it can hold the permanent and temporary address of the employee.

Expert Solution

Program Plan Intro

(h)

Definition of associative entity.

Explanation of Solution

Associative entity provides association between the given entity set or instance. An entity is associative only if it has all the entity set or instance involved in the many relationships. The result associative entity should be independent.

Expert Solution

Program Plan Intro

(i)

Definition of cardinality constraints.

Explanation of Solution

Cardinality constraints specify the number of elements associated with each other between the two tables. It can be of two types; minimum cardinality and maximum cardinality.

Expert Solution

Program Plan Intro

(j)

Definition of weak entity.

Explanation of Solution

Weak entity depends on another entity for its existence. And it has no importance or existence if the dependent entity does not exist. Example of weak entity can be room, as it depends on building and can exist only if there is any building.

Expert Solution

Program Plan Intro

(k)

Definition of Binary relationship.

Explanation of Solution

Binary relationship is used between the instances of two types and are among the most common types of relationship encountered. It supports three types of cardinalities:

i) one to one: consider an example of employee, each employee has its own parking area. Or we can say that the parking area is assigned to the employee.

ii) one to many: it indicates that one product is connected to others through a common product line.

iii) many to many: many students can do many courses and vice versa.

Expert Solution

Program Plan Intro

(l)

Definition of Derived attribute.

Explanation of Solution

Derived attribute can be calculated by using the related attributes. Suppose we must find the tenure of an employee, to find age, we need the date of birth and the date of joining of the employee. Thus, tenure of an employee is a derived attribute.

Expert Solution

Program Plan Intro

(m)

Definition of business rule.

Explanation of Solution

Business rules are used to provide direction to business and help to lead the progress of the business project. Some business rules are important as they provide logical schema. Database designers need to follow the business rules during the development of the database as per the directions provided by the honor of code. These rules are also used for maintaining the integrity and accuracy of data.

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 2, Problem 2.1RQ

Define each of the following terms:

entity type
entity-relationship model
entity instance
Attribute
relationship type
strong entity type
multivalued attribute
associative entity
cardinality constraint
weak entity
binary relationship
derived attribute
business rule

Expert Solution

Program Plan Intro

(a)

Definition of Entity type.

Explanation of Solution

Entity type can be defined as a set of entities which share some common characteristics, behavior and attributes.

Expert Solution

Program Plan Intro

(b)

Definition of Entity-relational model.

Explanation of Solution

Entity-relational model represents the logical relationship between the entities and attributes in the database for an organization. it helps in creating database easily and can be understood by all. E-R model can be expressed as entity-relationship diagram also called as (ERD diagram).

Expert Solution

Program Plan Intro

(c)

Definition of entity instance.

Explanation of Solution

Entity instance is single occurrence of entity type. Consider an example, suppose employee is an entity type which has many instances. Example of instances can be John, Jenny or any other employee.

Expert Solution

Program Plan Intro

(d)

Definition of attribute.

Explanation of Solution

Every entity instance or set has its own attributes. Attributes state the behavior and characteristics of the entity. consider an example of employee here employee is the entity set that consists of various attributes such as name, address, location, employee id, mobile number etc., which states the characteristics of the entity instance or set.

Expert Solution

Program Plan Intro

(e)

Definition of relationship type.

Explanation of Solution

Relationship type is the meaningful representation of data between the entity set. It is of four types:

i) one to one relationship: in this type of relationship, one record of the table is associated with one record of another table.

ii) one to many relationships: In this type of relationship, one record of first table can be associated with N numbers of records of the other table.

iii) many to one relationship: In this type of relationship, many or N number of records of the first table can be associated with one record of the other table.

iv) many to many relationshipsIn this type of relationship N number of records of first table can be associated with N numbers of records of the other table.

Expert Solution

Program Plan Intro

(f)

Definition of Strong entity type.

Explanation of Solution

Strong entity type: Strong entity is an entity which is not dependent on any other entity. For example, tire can be considered as an example of the strong entity as its existence does not depend on any vehicle entity set.

Expert Solution

Program Plan Intro

(g)

Definition of multi-valued attribute.

Explanation of Solution

Multivalued attributes are those which takes some values from the entity instance. For example, in the employee entity set address is a multi-value attribute it can hold the permanent and temporary address of the employee.

Expert Solution

Program Plan Intro

(h)

Definition of associative entity.

Explanation of Solution

Associative entity provides association between the given entity set or instance. An entity is associative only if it has all the entity set or instance involved in the many relationships. The result associative entity should be independent.

Expert Solution

Program Plan Intro

(i)

Definition of cardinality constraints.

Explanation of Solution

Cardinality constraints specify the number of elements associated with each other between the two tables. It can be of two types; minimum cardinality and maximum cardinality.

Expert Solution

Program Plan Intro

(j)

Definition of weak entity.

Explanation of Solution

Weak entity depends on another entity for its existence. And it has no importance or existence if the dependent entity does not exist. Example of weak entity can be room, as it depends on building and can exist only if there is any building.

Expert Solution

Program Plan Intro

(k)

Definition of Binary relationship.

Explanation of Solution

Binary relationship is used between the instances of two types and are among the most common types of relationship encountered. It supports three types of cardinalities:

i) one to one: consider an example of employee, each employee has its own parking area. Or we can say that the parking area is assigned to the employee.

ii) one to many: it indicates that one product is connected to others through a common product line.

iii) many to many: many students can do many courses and vice versa.

Expert Solution

Program Plan Intro

(l)

Definition of Derived attribute.

Explanation of Solution

Derived attribute can be calculated by using the related attributes. Suppose we must find the tenure of an employee, to find age, we need the date of birth and the date of joining of the employee. Thus, tenure of an employee is a derived attribute.

Expert Solution

Program Plan Intro

(m)

Definition of business rule.

Explanation of Solution

Business rules are used to provide direction to business and help to lead the progress of the business project. Some business rules are important as they provide logical schema. Database designers need to follow the business rules during the development of the database as per the directions provided by the honor of code. These rules are also used for maintaining the integrity and accuracy of data.

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

Program Plan Intro

(a)

Definition of Entity type.

Explanation of Solution

Entity type can be defined as a set of entities which share some common characteristics, behavior and attributes.

Expert Solution

Program Plan Intro

(b)

Definition of Entity-relational model.

Explanation of Solution

Entity-relational model represents the logical relationship between the entities and attributes in the database for an organization. it helps in creating database easily and can be understood by all. E-R model can be expressed as entity-relationship diagram also called as (ERD diagram).

Expert Solution

Program Plan Intro

(c)

Definition of entity instance.

Explanation of Solution

Entity instance is single occurrence of entity type. Consider an example, suppose employee is an entity type which has many instances. Example of instances can be John, Jenny or any other employee.

Expert Solution

Program Plan Intro

(d)

Definition of attribute.

Explanation of Solution

Every entity instance or set has its own attributes. Attributes state the behavior and characteristics of the entity. consider an example of employee here employee is the entity set that consists of various attributes such as name, address, location, employee id, mobile number etc., which states the characteristics of the entity instance or set.

Expert Solution

Program Plan Intro

(e)

Definition of relationship type.

Explanation of Solution

Relationship type is the meaningful representation of data between the entity set. It is of four types:

i) one to one relationship: in this type of relationship, one record of the table is associated with one record of another table.

ii) one to many relationships: In this type of relationship, one record of first table can be associated with N numbers of records of the other table.

iii) many to one relationship: In this type of relationship, many or N number of records of the first table can be associated with one record of the other table.

iv) many to many relationshipsIn this type of relationship N number of records of first table can be associated with N numbers of records of the other table.

Expert Solution

Program Plan Intro

(f)

Definition of Strong entity type.

Explanation of Solution

Strong entity type: Strong entity is an entity which is not dependent on any other entity. For example, tire can be considered as an example of the strong entity as its existence does not depend on any vehicle entity set.

Expert Solution

Program Plan Intro

(g)

Definition of multi-valued attribute.

Explanation of Solution

Multivalued attributes are those which takes some values from the entity instance. For example, in the employee entity set address is a multi-value attribute it can hold the permanent and temporary address of the employee.

Expert Solution

Program Plan Intro

(h)

Definition of associative entity.

Explanation of Solution

Associative entity provides association between the given entity set or instance. An entity is associative only if it has all the entity set or instance involved in the many relationships. The result associative entity should be independent.

Expert Solution

Program Plan Intro

(i)

Definition of cardinality constraints.

Explanation of Solution

Cardinality constraints specify the number of elements associated with each other between the two tables. It can be of two types; minimum cardinality and maximum cardinality.

Expert Solution

Program Plan Intro

(j)

Definition of weak entity.

Explanation of Solution

Weak entity depends on another entity for its existence. And it has no importance or existence if the dependent entity does not exist. Example of weak entity can be room, as it depends on building and can exist only if there is any building.

Expert Solution

Program Plan Intro

(k)

Definition of Binary relationship.

Explanation of Solution

Binary relationship is used between the instances of two types and are among the most common types of relationship encountered. It supports three types of cardinalities:

i) one to one: consider an example of employee, each employee has its own parking area. Or we can say that the parking area is assigned to the employee.

ii) one to many: it indicates that one product is connected to others through a common product line.

iii) many to many: many students can do many courses and vice versa.

Expert Solution

Program Plan Intro

(l)

Definition of Derived attribute.

Explanation of Solution

Derived attribute can be calculated by using the related attributes. Suppose we must find the tenure of an employee, to find age, we need the date of birth and the date of joining of the employee. Thus, tenure of an employee is a derived attribute.

Expert Solution

Program Plan Intro

(m)

Definition of business rule.

Explanation of Solution

Business rules are used to provide direction to business and help to lead the progress of the business project. Some business rules are important as they provide logical schema. Database designers need to follow the business rules during the development of the database as per the directions provided by the honor of code. These rules are also used for maintaining the integrity and accuracy of data.

Answer 8

Expert Solution

Program Plan Intro

(a)

Definition of Entity type.

Explanation of Solution

Entity type can be defined as a set of entities which share some common characteristics, behavior and attributes.

Answer 9

Expert Solution

Answer 10

Expert Solution

Answer 11

Expert Solution

Answer 12

Program Plan Intro

(a)

Definition of Entity type.

Answer 13

Explanation of Solution

Entity type can be defined as a set of entities which share some common characteristics, behavior and attributes.

Answer 14

Expert Solution

Program Plan Intro

(b)

Definition of Entity-relational model.

Explanation of Solution

Entity-relational model represents the logical relationship between the entities and attributes in the database for an organization. it helps in creating database easily and can be understood by all. E-R model can be expressed as entity-relationship diagram also called as (ERD diagram).

Answer 15

Expert Solution

Answer 16

Expert Solution

Answer 17

Expert Solution

Answer 18

Program Plan Intro

(b)

Definition of Entity-relational model.

Answer 19

Explanation of Solution

Entity-relational model represents the logical relationship between the entities and attributes in the database for an organization. it helps in creating database easily and can be understood by all. E-R model can be expressed as entity-relationship diagram also called as (ERD diagram).

Answer 20

Expert Solution

Program Plan Intro

(c)

Definition of entity instance.

Explanation of Solution

Entity instance is single occurrence of entity type. Consider an example, suppose employee is an entity type which has many instances. Example of instances can be John, Jenny or any other employee.

Answer 21

Expert Solution

Answer 22

Expert Solution

Answer 23

Expert Solution

Answer 24

Program Plan Intro

(c)

Definition of entity instance.

Answer 25

Explanation of Solution

Entity instance is single occurrence of entity type. Consider an example, suppose employee is an entity type which has many instances. Example of instances can be John, Jenny or any other employee.

Answer 26

Expert Solution

Program Plan Intro

(d)

Definition of attribute.

Explanation of Solution

Every entity instance or set has its own attributes. Attributes state the behavior and characteristics of the entity. consider an example of employee here employee is the entity set that consists of various attributes such as name, address, location, employee id, mobile number etc., which states the characteristics of the entity instance or set.

Answer 27

Expert Solution

Answer 28

Expert Solution

Answer 29

Expert Solution

Answer 30

Program Plan Intro

(d)

Definition of attribute.

Answer 31

Explanation of Solution

Every entity instance or set has its own attributes. Attributes state the behavior and characteristics of the entity. consider an example of employee here employee is the entity set that consists of various attributes such as name, address, location, employee id, mobile number etc., which states the characteristics of the entity instance or set.

Answer 32

Expert Solution

Program Plan Intro

(e)

Definition of relationship type.

Explanation of Solution

Relationship type is the meaningful representation of data between the entity set. It is of four types:

i) one to one relationship: in this type of relationship, one record of the table is associated with one record of another table.

ii) one to many relationships: In this type of relationship, one record of first table can be associated with N numbers of records of the other table.

iii) many to one relationship: In this type of relationship, many or N number of records of the first table can be associated with one record of the other table.

iv) many to many relationshipsIn this type of relationship N number of records of first table can be associated with N numbers of records of the other table.

Answer 33

Expert Solution

Answer 34

Expert Solution

Answer 35

Expert Solution

Answer 36

Program Plan Intro

(e)

Definition of relationship type.

Answer 37

Explanation of Solution

Relationship type is the meaningful representation of data between the entity set. It is of four types:

i) one to one relationship: in this type of relationship, one record of the table is associated with one record of another table.

ii) one to many relationships: In this type of relationship, one record of first table can be associated with N numbers of records of the other table.

iii) many to one relationship: In this type of relationship, many or N number of records of the first table can be associated with one record of the other table.

iv) many to many relationshipsIn this type of relationship N number of records of first table can be associated with N numbers of records of the other table.

Answer 38

Expert Solution

Program Plan Intro

(f)

Definition of Strong entity type.

Explanation of Solution

Strong entity type: Strong entity is an entity which is not dependent on any other entity. For example, tire can be considered as an example of the strong entity as its existence does not depend on any vehicle entity set.

Answer 39

Expert Solution

Answer 40

Expert Solution

Answer 41

Expert Solution

Answer 42

Program Plan Intro

(f)

Definition of Strong entity type.

Answer 43

Explanation of Solution

Strong entity type: Strong entity is an entity which is not dependent on any other entity. For example, tire can be considered as an example of the strong entity as its existence does not depend on any vehicle entity set.

Answer 44

Expert Solution

Program Plan Intro

(g)

Definition of multi-valued attribute.

Explanation of Solution

Multivalued attributes are those which takes some values from the entity instance. For example, in the employee entity set address is a multi-value attribute it can hold the permanent and temporary address of the employee.

Answer 45

Expert Solution

Answer 46

Expert Solution

Answer 47

Expert Solution

Answer 48

Program Plan Intro

(g)

Definition of multi-valued attribute.

Answer 49

Explanation of Solution

Multivalued attributes are those which takes some values from the entity instance. For example, in the employee entity set address is a multi-value attribute it can hold the permanent and temporary address of the employee.

Answer 50

Expert Solution

Program Plan Intro

(h)

Definition of associative entity.

Explanation of Solution

Associative entity provides association between the given entity set or instance. An entity is associative only if it has all the entity set or instance involved in the many relationships. The result associative entity should be independent.

Answer 51

Expert Solution

Answer 52

Expert Solution

Answer 53

Expert Solution

Answer 54

Program Plan Intro

(h)

Definition of associative entity.

Answer 55

Explanation of Solution

Associative entity provides association between the given entity set or instance. An entity is associative only if it has all the entity set or instance involved in the many relationships. The result associative entity should be independent.

Answer 56

Expert Solution

Program Plan Intro

(i)

Definition of cardinality constraints.

Explanation of Solution

Cardinality constraints specify the number of elements associated with each other between the two tables. It can be of two types; minimum cardinality and maximum cardinality.

Answer 57

Expert Solution

Answer 58

Expert Solution

Answer 59

Expert Solution

Answer 60

Program Plan Intro

(i)

Definition of cardinality constraints.

Answer 61

Explanation of Solution

Cardinality constraints specify the number of elements associated with each other between the two tables. It can be of two types; minimum cardinality and maximum cardinality.

Answer 62

Expert Solution

Program Plan Intro

(j)

Definition of weak entity.

Explanation of Solution

Weak entity depends on another entity for its existence. And it has no importance or existence if the dependent entity does not exist. Example of weak entity can be room, as it depends on building and can exist only if there is any building.

Answer 63

Expert Solution

Answer 64

Expert Solution

Answer 65

Expert Solution

Answer 66

Program Plan Intro

(j)

Definition of weak entity.

Answer 67

Explanation of Solution

Weak entity depends on another entity for its existence. And it has no importance or existence if the dependent entity does not exist. Example of weak entity can be room, as it depends on building and can exist only if there is any building.

Answer 68

Expert Solution

Program Plan Intro

(k)

Definition of Binary relationship.

Explanation of Solution

Binary relationship is used between the instances of two types and are among the most common types of relationship encountered. It supports three types of cardinalities:

i) one to one: consider an example of employee, each employee has its own parking area. Or we can say that the parking area is assigned to the employee.

ii) one to many: it indicates that one product is connected to others through a common product line.

iii) many to many: many students can do many courses and vice versa.

Answer 69

Expert Solution

Answer 70

Expert Solution

Answer 71

Expert Solution

Answer 72

Program Plan Intro

(k)

Definition of Binary relationship.

Answer 73

Explanation of Solution

Binary relationship is used between the instances of two types and are among the most common types of relationship encountered. It supports three types of cardinalities:

i) one to one: consider an example of employee, each employee has its own parking area. Or we can say that the parking area is assigned to the employee.

ii) one to many: it indicates that one product is connected to others through a common product line.

iii) many to many: many students can do many courses and vice versa.

Answer 74

Expert Solution

Program Plan Intro

(l)

Definition of Derived attribute.

Explanation of Solution

Derived attribute can be calculated by using the related attributes. Suppose we must find the tenure of an employee, to find age, we need the date of birth and the date of joining of the employee. Thus, tenure of an employee is a derived attribute.

Answer 75

Expert Solution

Answer 76

Expert Solution

Answer 77

Expert Solution

Answer 78

Program Plan Intro

(l)

Definition of Derived attribute.

Answer 79

Explanation of Solution

Derived attribute can be calculated by using the related attributes. Suppose we must find the tenure of an employee, to find age, we need the date of birth and the date of joining of the employee. Thus, tenure of an employee is a derived attribute.

Answer 80

Expert Solution

Program Plan Intro

(m)

Definition of business rule.

Explanation of Solution

Business rules are used to provide direction to business and help to lead the progress of the business project. Some business rules are important as they provide logical schema. Database designers need to follow the business rules during the development of the database as per the directions provided by the honor of code. These rules are also used for maintaining the integrity and accuracy of data.

Answer 81

Expert Solution

Answer 82

Expert Solution

Answer 83

Expert Solution

Answer 84

Program Plan Intro

(m)

Definition of business rule.

Answer 85

Explanation of Solution

Business rules are used to provide direction to business and help to lead the progress of the business project. Some business rules are important as they provide logical schema. Database designers need to follow the business rules during the development of the database as per the directions provided by the honor of code. These rules are also used for maintaining the integrity and accuracy of data.