Database Management I: Section 1-3 Test

Which symbol is used to show that a particular attribute is mandatory? & * # o

*

What does single table refer to? (Choose Two) (Choose all correct answers) -A fully-relational database system like Microsoft's SQL Server or Oracle's database systems. -A database where all of the data is stored in one large table. -A type of database storage method where all of the data elements are stored on top of each other. -Non-relational systems that typically store each table and index in separate files and often do not support the SQL language.

-A database where all of the data is stored in one large table. -Non-relational systems that typically store each table and index in separate files and often do not support the SQL language.

Which of the following are suitable Entity names? (Choose Two) -ANIMAL -DOG -DOGS -ANIMALS

-ANIMAL -DOG

In a business that sells pet food, choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two) (Choose all correct answers) -Each ANIMAL must be the seller of one or more FOOD TYPES. -Each FOOD TYPE may be made from one or more ANIMALS. -Each FOOD TYPE may be given to one or more ANIMALS. -Each FOOD TYPE must be suitable for one or more ANIMALS.

-Each FOOD TYPE may be given to one or more ANIMALS. -Each FOOD TYPE must be suitable for one or more ANIMALS.

When creating entities in a logical model you must follow these rules: (Choose Two) (Choose all correct answers) -Exclude Attributes -Include Attributes -Name them in Singular -Name them in Plural

-Include Attributes -Name them in Singular

In a physical data model, a relationship is represented as a combination of: (Choose Two) (Choose all correct answers) -Check Constraint or Unique Key -Column -Primary Key or Unique Key -Foreign Key

-Primary Key or Unique Key -Foreign Key

A DBMS comprises of the following elements: (Choose 3)(Choose all correct answers) -Query language -Client -Data Dictionary -Memory and Storage Management

-Query language -Data Dictionary -Memory and Storage Management

Which of the following statements are true? (Choose two) (Choose all correct answers) -Flat file database systems pay more attention to retrieving data and making it accessible to the user, whereas relational databases spend more energy updating indexes and data pointers. -Relational database systems are the main thrust behind SQL since it provides the language elements needed to tie together the information in the database. -Relational systems pay more attention to retrieving data and making it accessible to the user. -Flat file database structures help eliminate redundant information.

-Relational database systems are the main thrust behind SQL since it provides the language elements needed to tie together the information in the database. -Relational systems pay more attention to retrieving data and making it accessible to the user.

All ER diagrams must have one of each of the following: (Choose two) (Choose all correct answers) -Arcs -Relationships between entities -At least one supertype and subtype -One or more Entities

-Relationships between entities -One or more Entities

Data modelling is performed for the following reasons: (Choose Two) (Choose all correct answers) -The ERD becomes a blueprint for designing the actual system. -We do not need datamodels; we can just start coding right away. -We draw an ERD solely to please the users; once completed, the ERD is never referred to again as it serves no purpose in the real world. -It helps discussions and reviews.

-The ERD becomes a blueprint for designing the actual system. -It helps discussions and reviews.

A table is in 1NF if ... (Choose all correct answers) -There are no duplicate rows -There is only one data value. -The entries in a column are of different type -Each row contains different columns

-There are no duplicate rows -There is only one data value.

Which of the following statements about attributes are true? (Choose Two) (Choose all correct answers) -They describe, qualify, quantify, classify, or specify an entity. -They are the primary container for data. -They must be single valued unless they belong to more than one entity. -They are often adjectives

-They describe, qualify, quantify, classify, or specify an entity. -They are often adjectives

Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. (Choose all correct answers) -They model functional and informational needs. -They capture the implementation details of the physical model. -They capture current and future needs. -They accurately describe what a physical model will contain. -They capture the data values.

-They model functional and informational needs. -They capture current and future needs. -They accurately describe what a physical model will contain.

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

1st normal form

According to ___________, an attribute must be dependent on its entity's entire unique identifier.

2nd normal form

The strategies for learning used in this course include: -Instructor led training -Industry recognized certification -Project driven curriculum -All of the above

All of the above

When completing the conceptual modeling process we must take into account the following: -Business Rules -Assumptions -Problems -All of the above

All of the above

Which of the following are reasons we create conceptual models? -It facilitates discussion; a picture is worth a thousand words -It forms important ideal system documentation -It takes into account government regulations and laws -It forms a sound basis for physical database design -All of the above

All of the above

A relationship can be between ____________. -two entities -an entity and itself -multiple entities -All of the above.

All of the above.

Normalization is the process of organizing the attributes and entities of a relational database to minimize ______________ -redundancy -data inconsistencies -anomalies -All of the above.

All of the above.

Select the business or industry that would not have a need for a database. -Banking -Retail -Scientific Research -All these businesses could benefit from using a database.

All these businesses could benefit from using a database.

When mapping a many to many relationship it must first be resolved using _____________.

An intersection entity

People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. A shoe has a color, a size, a style, but may not have a descriptive "number." So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created.

Artificial

A/an _________ is a piece of information that in some way describes an entity. It is a property of the entity and it quantifies, qualifies, classifies, or specifies the entity.

Attribute

Intersection Entities are at the ______ end of the newly created 1:M (Parent:Child) relationship;

Barred

The advantages of an object-oriented data model are: -Reduced Maintenance -Real-World Modeling -Both of the above -Neither of the above

Both of the above

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? -Daily traffic patterns must be monitored to determine how many law enforcement officers are needed. -If you are doing a system for any French City, you would need security clearance. -People are born in the city and people die in the city. -Cites may change their names and/or country association if the borders of a country change.

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

Which transformation in computing allows for storage and delivery of applications and data over the internet? -Cloud Computing -Mainframe computing -Grid Computing -Desktop computing

Cloud Computing

A unique identifier made up of more than one attribute is called a _______________.

Composite UID

An ERD is an example of a ______ Model.

Conceptual

What is the difference between "information" and "data"?

Data turns into useful information. It is stored in a database and accessed by systems and users.

Which of the following transformations in computing led to the increase in graphical user interface (GUI) applications? -Mainframe computing -Desktop computing -Grid Computing -Client/Server Computing

Desktop computing

A _________ on a relationship line indicates the Relationship as Non-Tranferable.

Diamond

Unique Identifiers... -Distinguish nothing -Distinguish one entity from another. -Distinguish one instance of an entity from all other instances of that entity -Distinguish all entities in a database

Distinguish one instance of an entity from all other instances of that entity

The conceptual model does all of the following except: -Prevents mistakes and misunderstandings. -Takes into account regulations and laws governing the industry being addressed. -Describes the needs of the business. -Documents type of operating system to be used.

Documents type of operating system to be used.

Which of the following entities most likely contains invalid attributes? -Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built -Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed -Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children -Entity: Pet. Attributes: Name, Birthdate, Owner

Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed

A unique identifier must be made up of more than one attribute. True or False?

False

All relationships participating in an arc must be mandatory. True or False?

False

Attributes have Instances. True or False?

False

Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?

False

T/F: A Unique Identifier has a NULL value for each instance of the entity for the lifetime of the instance.

False

T/F: All Business Rules can be modeled.

False

T/F: ERDish is a language used to create database structures in SQL

False

The physical model shows all table structures. True or False.

False

When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False?

False

You can only create relationships to a Supertype, not to a Subtype. True or False?

False

Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want. (true/false)

False. Business requirements can and will change. For instance, new legal requirements may arise.

In the relational model, relationships between relations or tables are created by using?

Foreign Keys

In a __________ database model the data is organized into a tree-like structure and to retrieve data the whole tree needs to be traversed starting from the root node.

Hierarchical

Using a database solution instead of a flat file eliminates all of the following issues except: -Incorrect data -Data entry anomalies -Rednunancy -Inconsistency

Incorrect data

Which of the following is not true regarding normalization: -It helps with the performance of the database. -It assists in handling insert, update and delete anomalies. -It does not impact the performance of the database. -It is the process of organizing the attributes and tables of a relational database to minimize redundancy.

It does not impact the performance of the database.

Which of the following is not a goal of ER modeling: -Locate information in a logical manner -Capture all required information. -It is acceptable to include information that is derivable. -Ensure information appears only once.

It is acceptable to include information that is derivable.

The _______________ model includes entities, attributes, UIDs, relationships as well as optionality and cardinality of these items.

Logical

The transformations that have occurred in the computing world progressing in this order: -Mainframe Computing, Desktop Computing, Grid Computing, Client/Server Computing. -Desktop computing, Grid computing, Client/Server computing, Mainframe computing. -Grid Computing, Desktop Computing, Mainframe Computing, Client/Server Computing. -Mainframe computing, Desktop computing, Client/Server Computing, Grid computing. .

Mainframe computing, Desktop computing, Client/Server Computing, Grid computing.

The optionality of a relationship must be either __________ or ____________.

Mandatory or Optional

Can all constraints be modeled on an ER diagram?

No, and those that cannot be modeled should be listed on a separate document to be handled programmatically

If a relationship can NOT be moved between instances of the entities it connects, it is said to be:

Non-Transferable

Until all attributes are single-valued, the database model is said to be:

Not Normalized

Entities are usually _____________.

Nouns

Which of the following is not an advantage of a relational database? -One table with all the data. -Data Integrity -Efficiency -Less Redundancy

One table with all the data.

A conceptual model includes:

Only Entities and Relationships

The transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become __________ and relationships become ____________.

Primary keys, Foreign keys

The components of a relationship include all of the following except: -Cardinality -Names -Optionality -Relational Integrity

Relational Integrity

Which of the following statements does not apply to relational databases? -Relational databases are simple to understand. -Relational databases have a strong procedural orientation. -Relational databases relate tables to each other using common fields called keys. -Tables are one of the basic components of relational databases.

Relational databases are simple to understand.

Attribute names are converted to column names by _________________.

Replacing spaces with underscores.

Business _____ are used to understand business procedures, and the nature, role, and scope of the data.

Rules

Which of the following is NOT a relationship type? -One to Many -Some to None -Many to Many -One to One

Some to None

Table names can contain all of the following except: -Some special characters -Letters -Numbers -Spaces

Spaces

Which is the first step in the Database Development Process?

Strategy and Analysis

Which of the following is true about subtypes? -Subtypes should not be exhaustive. -Subtypes must not be mutually exclusive. -One instance of a supertype may belong to two subtypes. -Subtypes must be mutually exclusive.

Subtypes must be mutually exclusive.

Which of the following pairs of entities is most likely to be modeled as a M:M relationship? -TEACHER and SUBJECT AREA -PERSON and FINGERPRINT -TREE and BRANCH -CAR and WHEEL

TEACHER and SUBJECT AREA

Business rules are important because _______.

They allow the developer to understand the relationship and constraints of the participating entities

What is the purpose of a Unique Identifier?

To identify one unique instance of an entity by using one or more attributes and/or relationships.

Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database. True or False?

True

Matrix Diagrams should be developed BEFORE the ERD. True or False?

True

SQL *Plus is being used in the Oracle Academy courses to run SQL code. True or False?

True

T/F: A database is a centralized and structured set of data stored on a computer system and provides facilities for retrieving, adding, modifying, and deleting the data when required.

True

T/F: A flat file may contain many fields, often, with duplicate data that are prone to data corruption.

True

T/F: A foreign key is a column or combination of columns in one table that uniquely identifies a row of another table.

True

T/F: A network database comprises of a collection of records connected to one another through links.

True

T/F: A table is in 3NF if it has met all database requirements for both 1NF and 2NF and all transitive dependencies are eliminated.

True

T/F: Business rules help you understand the standardization procedure an organization follows when handling huge data.

True

T/F: If there is a column missing in an entity - normalization should identify this problem.

True

T/F: In the relational database model, each table name must be unique. The column names in the table must be unique too. You can have two different tables that have column names that are the same.

True

T/F: Information is the result of combining, comparing and performing calculations on data.

True

T/F: When mapping a barred relationship a primary key and foreign key can be the same field.

True

T/F: When mapping a relationship for an ERD relationship names must be included.

True

The "Other" subtype is mandatory. True or False?

True

The Physical Model is derived from the Logical Model. True or False?

True

Which of the following statements about entity relationship diagrams (ERD) is true? -Used to communicate the physical structure of the database to users. -Used to communicate the logical structure of the database to users. -Is a hard and fast document that cannot be changed once development of the database has begun. -Used to communicate the technical specifications of the database to users

Used to communicate the logical structure of the database to users.

When is an entity in 2nd Normal Form?

When all non-UID attributes are dependent upon the entire UID.

In an ERD diagram how is an optional relationship represented?

With a dotted line

Sources of business rules include all of the following except: -Standards -Word of mouth -Procedures -Operational manuals

Word of mouth

The candidate UID that is chosen to identify an entity is called Primary UID; other candidates UIDs are called Secondary UIDs. -No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc. -No, it is not possible to have more than one UID for an Entity. -Yes, this is the way UID's are named. -No, each Entity an only have one UID, the secondary one.

Yes, this is the way UID's are named.

An ERD created using ERDish is a __________ representation of entities and their relationships to each other.

graphical

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

intersection entity

In a hierarchical database model the data is stored as records that are connected to one through ________.

links

Relationships are mapped in a physical model using ____________ keys and foreign keys.

primary

Matrix Diagrams are used to verify that all _______________ have been identified for an ERD.

relationships