[SOLVED] MSDS7330- Assignment 2

Description

This is a homework assignment for MSDS7330, File Organization and Database Management. This quiz is due at the end of the synchronous class period in which the unit is discussed or whenever the instructor turns you to hand it in; whichever comes first. Enter your answer to each question in the MSDS 7330 Homework Answer Sheet Word document. Be sure to place your name and due date in the Homework Answer Sheet, and place your last name and the homework number at the beginning of the file name. For example, the filename for the homework answer sheet for homework 2 for Sohail Rafiqi should be Rafiqi2MSDS7330HomeWorkAnswerSheet.docx.

For each question, in the Homework Answer Sheet state the letter of your chosen answer and write out the explanation why the answer is correct. Note that the explanation involves also explaining why the other answers are not correct.

Your answer Word document should be submitted on the Canvas system for the quiz number equal to the homework number. For example, the homework 2 should be submitted for homework

assignment 2.

• The Entity-Relationship model is
  1. a way to graphically represent the logical relation-ships of entities in a database.
  2. a way to graphically represent the data in adatabase.
  3. a way to graphically represent only the constraintsin a database.
  4. a way to graphically represent strong entity setsbut not weak entity sets.
• In the Entity-Relationship model, to what does an entity refer (or represent)?
  1. The organization in which the model is created.
  2. A distinctly identifiable item, thing or object.
  3. A particular instance of data.
  4. A database schema.
• An entity set is
  1. a collection of databases.
  2. a collection of relationships connecting a singleentity to many other entities.
  3. a collection of entities of the same type that sharethe same properties.
  4. a collection of attribute values that are the sameacross all entities.
• Entities can be associated with one another by using which of the following?
  1. Entities
  2. Attributes
  3. Identifiers
  4. Relationships
• In a one-to-many relationship, the entity that is on the many side of the relationship is called what type of entity?
  1. parent
  2. child
  3. instance
  4. subtype
• In an Entity-Relationship model, attributes may be which of the following?
  1. simple
  2. composite
  3. multi-valued
  4. All of the above.
  5. None of the above.
• In an Entity-Relationship model, relationship sets are represented by which of the following?
  1. Rectangles
  2. Diamonds
  3. Lines
  4. Ovals
• Directed lines from a relationship set to all of its related entity sets indicates which type of relationship?
  1. One-to-one
  2. One-to-many
  3. Many-to-one

1. Many-to-many

• Consider the entity set instructor containing the attributes ID, name, deptName and salary with ID as the primary key and the entity set department containing the attributes deptName, building and budget with deptName as the primary key. In order to represent the relationship between instructor and department we need to do which of the following?
  1. The relationship is properly representedby the deptName attribute in the instructor entity set.
  2. Add a one-to-one relationship instructorDepartment that explicitly relates instructor to department and leave the entity sets unchanged.
  3. Add a one-to-one relationship instructorDepartment that explicitly relates instructor to department and remove the deptName attribute from the instructor entity set.
  4. Add a one-to-many relationship instructorDepartment that explicitly relates instructor to department and remove the deptName attribute from the instructor entity set.
• Which of the following is NOT a basic element of the Chen version of the E-R model?
  1. Entities
  2. Attributes
  3. Relationships
  4. All of the above.
  5. None of the above.
• An attribute that names or identifies entity instances is a(n):
  1. entity
  2. attribute
  3. identifier
  4. relationship
• In an Entity-Relationship model, double lines connecting

2

an entity set to a relationship set indicates which of the following?

1. Two constraints on the entity set.
2. Every entity participates in up to two relationshipsof the given type.
3. Some entities participate in more than one relation-ship of the given type.
4. Every entity participates in at least one relationshipof the given type.

• Relationship sets can be used to directly represent which of the following?
  1. Entity attributes.
  2. Relationships between attribute values.
  3. Relationship between multiple entity sets.
  4. All of the above.
  5. None of the above.
• In the Entity-Relationship model, attributes may be represented as which of the following?
  1. The only name within the top of a double sectionedrectangle.
  2. Ovals
  3. Names above lines
  4. The only name within a diamond.
• In crow’s foot notation of the Entity-Relationship model, consider the simple ER model of entity E1 and entity E2 connected by a relationship line R where the line ends in a crow’s foot at E1 but ends simply as a line at E2. This represents which of the following relationship types?
  1. One-to-one
  2. Many-to-one
  3. One-to-many
  4. Many-to-many