These are statements that define or constrainsome aspect of the business.

The following are characteristics of a good data name except one

It is a collection of entities

Which of the following statements is not correct about ER Models?

A SUPPLIER may send many SHIPMENTs. However, each shipment must be sent by exactly one SUPPLIER. 

Which of the following ER Model best represent the given business rule?

It is an attribute or a combination of attributes that uniquely identifies individual instances of an entity type.

It is an attribute that is both not null and unique which satisfies the conditions of an identifier

The following are characteristics of an identifier, except

Which of the following is a multivalued attribute of Employee Entity type?

Which of the following is a derived attribute of Employee Entity type?

Which of the following is a composite attribute of Employee Entity type?

The following statements are TRUE except

It refers tothe number of instances of one entity that can or must be associated with each instance of another entity

Which of the following describes a many to many cardinality of relationship?

Which of the following describes a one to many cardinality of relationship?

It refers to the number of participating entity types in the relationship

These are entity types that are dependent on a strong entity type.

A student may read any number of book. A book may be read by any number of students. What is the cardinality of the relationship between books and student?

A student may read any number of book. A book may be read by any number of students. What is the degree of the relationship between books and student?

A student may read any number of book. A book may be read by any number of students. Which ER Model best represents this relationship?

Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must register for classes with the help of an adviser, but if the student’s assigned adviser is not available, the student may register with any adviser. We must keep track of students, the assigned adviser for each, and the name of the adviser with whom the student registered for the current term. What entity types must be included in this scenario?

Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must register for classes with the help of an adviser, but if the student’s assigned adviser is not available, the student may register with any adviser. We must keep track of students, the assigned adviser for each, and the name of the adviser with whom the student registered for the current term.  1. What is the cardinality of the relationship between the adviser and the students assigned to him/her? 2. What is the cardinality of the relationship between the student and the adviser who registered the student in the class? Please write your answer in order, separated by a comma.

Create an ER model for each of the following descriptions:

(a) A large organization has several parking lots, which are used by staff.

(b) Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).

(c) Each parking lot has parking spaces, which are uniquely identified using a space number.

(d) Members of staff can request the sole use of a single parking space. Each member of staff has a unique num- ber, name, telephone extension number, and vehicle license number.

Select the correct ER models that represents all the given descirptions.

The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.

Question: What are the entity types to be included in the ER Model for this case problem?

The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.

Question: What is the cardinality between the borrower and the book?

The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.

Question: What is book loan?

The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.

Question: What is the cardinality of relationship between a book and book copy?