1. The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits.
Camper CAMPER_NUMBER None
Sport SPOT_NUMBER None
Reservation RESV_NUMBER CAMPER_NUMBER and SPOR_NUMBER
2. The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits.
Add the ends to the relations on the Crows Foot ERD for the campground reservation system.
Quiz: Chapter 03 The Relational Database Model
1. Which of the following is not a valid characteristic of a relational table?
All values in a column may have different data formats.
2. Which of the following statements best describes a functional dependency?
The value of one or more attributes determines the value of one or more other attributes.
3. Which of the following is not a legitimate DB key in a relational model?
Entity key
4. Which of the following statements best defines the purpose of entity integrity?
It guarantees each entity has a unique value for the primary key and that there are no null key values.
5. Dr. Codd published a list of 12 relational database rules in 1985; which of the following is not a valid rule?
Any database view that is theoretically updatable must be updated outside of the database structure
6. Which of the following best describes an index?
An index is an orderly arrangement used to logically access rows in a table.
7. A composite entity is also referred to as a _____ entity.
bridge
8. The proper use of foreign keys _____ data redundancies and the chances that destructive data anomalies will develop.
minimizes
9. Which of the following statements best defines a data dictionary?
The data dictionary provides a detailed description of all tables in the database created by the user and designer.
10. Which of the following is not a valid relational set operator?
ADD operator
Chapter 04 Use It
1. Provide the appropriate connectivity using the above business rules for number 1
∞:1
2. Provide the appropriate connectivity using the above business rules for number 2
1:∞
3. Provide the appropriate connectivity using the above business rules for number 3
1:∞
4. Provide the appropriate connectivity using the above business rules for number 4
∞:1
5. Provide the appropriate connectivity using the above business rules for number 5
1:∞
6. Provide the appropriate connectivity using the above business rules for number 6
1:∞
7. Provide the appropriate connectivity using the above business rules for number 7
∞:1
Quiz: Chapter 04 Entity Relationship (ER) Modeling
1.When working with entity relationship models (ERM), which of the following is not a valid statement regarding an entity?
An entity is an object of interest to the end designer
2. In an entity relationship model (ERM), attributes are characteristics of entities. Which of the following statements best describe an optional attribute?
An optional attribute is an attribute that does not require a value and can be left empty.
3. What type of attribute allows for no more than one value?
Single-valued attribute
4. The CUSTOMER entity includes the attributes CUST_LNAME, CUST_FNAME, CUST_PHONE, and CUST_PHONE_TYPE. The CUST_PHONE_TYPE attribute stores the string “HOME, WORK, MOBILE, OTHER”. Which term best describes CUST_PHONE_TYPE?
Multivalued attribute
5. A derived attribute is an attribute whose value is calculated (derived) from other attributes. What is not an advantage of storing derived attributes in the database?
Uses CPU processing cycles
6. What type of entity can exist in the database only when it is associated with another related entity?
Existence-dependent
7. What element expresses the specific number of entity occurrences associated with an occurrence of a related entity?
Cardinality
8. A relationship degree indicates the number of entities or participants associated with a relationship. Which is not a valid relationship that’s specifically named?
Quarterly relationship
9. Database designers must often compromise design due to conflicting goals. What are examples of contradictory goals in database design?
Design standards, processing speed, and information requirements
10. While a relationship degree indicates the number of entities associated with a relationship, which relationship type is within a single entity type?
Recursive relationship
Other Links:
See other websites for quiz:
Check on QUIZLET