Database Section 3 Quiz

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Would it be a good idea to model age as an attribute of STUDENT?

No - it is a volatile attribute

Which of the following is true about subtypes?

Subtypes must be mutually exclusive.

When converting attribute names to columns __________ are frequently used.

abbreviations

How many subtypes can a supertype have?

any number

A ___________ relationship is created when the UID for an entity includes the relationship with another entity.

barred

Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. (true/false)

true

Modeling historical data can produce a unique identifier that includes dates. (true/false)

true

Modeling historical data is optional.

true

Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain multiple values. (true/false)

true

The Rule of 3rd Normal Form states that No Non-UID attribute can be dependent on another non-UID attribute. (true/false)

true

We take the primary key from the "one" table and place it on the "many" table to create a foreign key. (true/false)

true

When mapping a barred relationship, a primary key and foreign key can be the same field. (true/false)

true

A table is in 2NF if A. It meets the requirements for the 1 NF. B. Each non-key attribute is fully functional dependent on the table's primary key. C. Both A and B must be true. D. Neither A or B must be true.

Both A and B must be true.

A recursive relationship has cardinality of ___________.

Cannot be determined without more information.

Which of the following would be a logical constraint when modeling time for a City entity? -Cites may change their names and/or country association if the borders of a country change. -People are born in the city and people die in the city. -If you are doing a system for any French City, you would need security clearance. -Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

Cites may change their names and/or country association if the borders of a country change.

An entity without repeated values is said to be in __________.

1st normal form

Which of the following scenarios should be modeled so that historical data is kept? (Choose two) (Choose all correct answers) -BABY and AGE -TEACHER and AGE -CUSTOMER and ORDERS -CUSTOMER and PAYMENTS

-CUSTOMER and ORDERS -CUSTOMER and PAYMENTS

In a physical data model, an attribute is represented as a/an

column

Arcs are used to visually represent _________ between two or more relationships in an ERD.

exclusivity

You can only create relationships to a Supertype, not to a Subtype. (true/false)

false

A ______________ is frequently used to track information about a relationship that changes over time.

intersection entity

A recursive relationship _____ mandatory at both ends.

may be

All instances of the supertype _____ be an instance of one of the subtypes.

must

As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. (true/false)

normalization

When data is only stored in one place in a database, the database conforms to the rules of ___________.

normalization

When mapping entities containing super types and subtypes a _________ table implementation is used when most of the attributes and relationships are shared at the super type level.

single-table

Table names can contain all of the following except:

spaces

A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. (true/false)

true

If there is a column missing in an entity - normalization should identify this problem. (true/false)

true


Ensembles d'études connexes

Bus Law Ch 16- Contracts: Performance and Discharge

View Set

Chapter 4 Sensation & Perception

View Set

Chapter 2 - Accounting: What the Numbers Mean

View Set

Arguments and Arguing Chapters 3 and 4

View Set

Chapter 42: Acute Renal Failure and Chronic Kidney Disease

View Set

Physics: Displacement and Velocity

View Set

QuickBooks Section 4 - Attempt 4/11/2021

View Set