1. Use the above business rules for the cruise database to answer what is the appropriate connector for number 1
2. Use the above business rules for the cruise database to answer what is the appropriate connector for number 2
∞:1
3. Use the above business rules for the cruise database to answer what is the appropriate connector for number 3
1:∞
4. Use the above business rules for the cruise database to answer what is the appropriate connector for number 4
∞:1
5. Captain: Using the above business rules select the best primary key(s) for each table.
ParrotID, EmployeeID
6. Employee: Using the above business rules select the best primary key(s) for each table.
EmployeeID
7. Crew: Using the above business rules select the best primary key(s) for each table.
DependentID, EmployeeID
8. Ships: Using the above business rules select the best primary key(s) for each table.
ShipID
9. ShipsMissions: Using the above business rules select the best primary key(s) for each table.
ShipID, MissionID
10. Missions: : Using the above business rules select the best primary key(s) for each table.
MissionID
11. Pet: Using the above business rules, select the best primary key for the Pet table.
PET_ID
12. Owner: Using the above business rules, select the best primary key for the Owner table.
OWNER_ID
13. Appointments: Using the above business rules, select the best primary key for the Appointments table.
APPOINTMENT_ID
14. Treatment_Appt: Using the above business rules, select the best primary key for the Treatment_Appt table.
TREATMENT_ID, APPOINTMENT_ID
15. Treatment: Using the above business rules, select the best primary key for the Treatment table.
TREATMENT_ID
16. Using the following business rules for the veterinarian database, provide the appropriate connector for number 1
17. Using the following business rules for the veterinarian database, the appropriate connector for number 2
18. Using the following business rules for the veterinarian database, provide the appropriate connector for number 3
19. Using the following business rules for the veterinarian database, provide the appropriate connector for number 1
20. Client: Using the above business rules, select the best primary key(s) for the client table
CLIENT_ID
21. CLIENT_TRIPS: Using the above business rules, select the best primary key(s) for the CLIENT_TRIPS table
CLIENT_ID, TRIP_ID
22. Trips: CLIENT_TRIPS: Using the above business rules, select the best primary key(s) for the TRIPS table
TRIP_ID
23. Trips_Guides: Using the above business rules, select the best primary key(s) for the Trips_Guides table
TRIP_ID, GUIDE_ID
24. Guides: Using the above business rules, select the best primary key(s) for the Guides table
GUIDE_ID
Quiz: Chapter 05 Advanced Data Modeling
1.When looking into the extended entity relationship model (EERM), which of the following statements is not valid about entity supertypes and subtypes?
The entity subtype contains common characteristics.
2. In an extended entity relationship, which of the following statements is not valid about inheritance?
Inheriting the relationships of their supertypes means subtypes cannot have relationships of their own.
3. In the extended entity-relationship model (EERM), which of the following statements best describes the completeness constraint?
The completeness constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
4. Which of the following statements is not valid when describing entity clustering?
An entity cluster is a permanent entity used to represent multiple entities and relationships, intended to simplify the ERD, and thus enhance its readability
5. Which of the following statements best describes the essential characteristic of an entity’s primary key?
The main function of the primary key is to guarantee entity integrity, not to “describe” the entity.
6. The primary key is possibly the most essential characteristic of an entity; which of the following is not a desirable characteristic of a primary key?
Intelligent
7. What primary key is created by the database designer to simplify the identification of entity instances?
A surrogate key
8. Identify the statement that best defines time-variant data.
Time-variant data refers to data that changes over time; its history of data changes must be maintained.
9. Which statement from the following describes specialization and generalization?
Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype. Generalization is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
10. Which of the following statements describe a fan trap in ERD design?
A fan trap occurs when there is one entity in two 1:M relationships to other entities
Chapter 06 Use It
- Scenario:
Jonny is appointed as an intern position, which might lead to a junior database architect role in TechTrend Corporation (TTC). Jonny is assigned to redesign two legacy tables related to “Suppliers,” to be normalization compliant. The following business rules are provided.
Business Rules:
- Suppliers can be local or national, thus can have multiple locations.
- Any location can supply items to TechTrend.
- Any location manager can have a separate pricing deal with TechTrend, based on production process specific to that location and localization
- Each location has a contact person assigned to TechTrend.
- Traditionally, TechTrend dealt with a singular location, at the most two. With rapid growth in business, the TTC officials are finding better leverage possibilities to negotiate beneficial terms with suppliers in multiple locations.
- The DB administrator has specifically requested Johnny to keep in mind the strategic business needs, while restructuring the tables.
- There are other tables within the database, which are beyond the context of this exercise.
Based on the table structures and business rules, you will match the following questions with the correct answers listed. Following, are the existing Legacy table structures. Next, you will see a list of questions displayed. You will drag column A to column B.
Your answers should be in coordination with concepts discussed in Chapter 6
Quiz: Chapter 06 Normalization of Database Tables
1. Normalization is a process for evaluating and correcting table structures to minimize _____.
data redundancy and anomalies
2. Which of the following is false about unnormalized data?
Unnormalized data is related data.
3. Which of the following is NOT true?
Fourth normal form (4NF): 3NF and no dependent multivalued dependencies
4. Which of the following statements best describes partial dependency?
A partial dependency exists when there is a functional dependence in which the determinant is only part of the primary key.
5. Which of the following statements best defines transitive dependency?
A condition in which an attribute is dependent on another attribute that is not part of the primary key
6. Repeating group is defined as _____.
a characteristic describing a group of multiple entries of the same or multiple types for a single key attribute occurrence
7. Atomicity refers to?
An attribute is atomic that cannot be further subdivided.
8. Which of the following is not valid about the ER model?
Should contain redundant relationships except as required
9. Which of the following is not valid related to attribute naming convention?
Should not use the entity abbreviation as a prefix
10. Which of the following is valid?
Each entity should represent a set of distinguishable entity instances.
Other Links:
See other websites for quiz:
Check on QUIZLET