Database Design Midterm Exam
Databases
are used in most countries and by most governments. Life, as we know it, would
change drastically if we no longer had access to databases. True or False?
True
(*)
False
Every time you shop online, it
is likely you will be accessing a database. True or False?
True
(*)
False
Which of the following
represents the correct sequence of steps in the Database Development Process?
Analyze,
Build, Design
Design,
Build, Analyze
Build,
Analyze, Design
Analyze,
Design, Build (*)
Which of the following are
examples of data becoming information:
A.
Student age -> average age of all students in class
B. Bank
deposit amount -> total account balance
C.
Winning time for a race -> length of race
D.
Price of a computer -> total sales of all computers for a company
E. A,
B, and D (*)
Consider your school library.
It will have a database with transaction details of the books that are borrowed
by students. Is the total number of books out on loan in one given month
considered Data or Information?
Data
Information
(*)
Both
Neither
The demand for Information Technology professionals in
today's market is increasing. True or False?
True
(*)
False
Which term describes the
physical components of a computer system?
Hardware
(*)
Client
Operating
System
Software
Users could directly interact
with which of the following software to access essential business applications?
(Choose three)
GUI
software (*)
Operating
System software (*)
Internet
Browser software (*)
Server
software
Businesses involved in any of
the following typically use databases to handle their data: Finance, Logistics,
Commerce, Procurement, and Distribution? True or False?
True
(*)
False
Changes in computing have
affected many of our day-to-day activities. Are all of the following activities
examples of this change? Yes or No?
In the past you used to use the phone system to call
directory assistance to get a phone number. Today you can use your PC to look
up a phone number online.
In the past you used to have to go to the shoe store to buy
shoes. Today you can use your PC to order shoes online.
In the past you had to use your PC to send a person an
email. Today you can use your phone to send a text message.
Yes (*)
No
A/an
_________ is defined as "Something" of significance to the business
about which data must be known.
Instance
Relationship
Entity
(*)
None of
the above
All of the following could be
attributes of an ENTITY called PERSON, except which one?
Gender
Weight
Natacha
Hansen (*)
Haircolor
Attributes can only have one
value at any point for each instance in the entity. True or False?
True
(*)
False
The word "Volatile"
means:
Changing
constantly; unstable (*)
Static;
unlikely to change
Large
quantity
Limited
quantity
Unique Identifiers:
Distinguish
all entities in a database
Distinguish
nothing
Distinguish
one entity from another
Distinguish
one instance of an entity from all other instances of that entity (*)
Which of the following statements about Entities are true?
They
never have Instances
A name
for a set of similar "things" (*)
"Something"
of significance to the business about which data must be known. (*)
They
are usually a noun. (*)
Which of the following statements
are true about ERD's?
A piece
of information can be shown multiple times on an ERD.
You
should not model derivable data. (*)
All
data must be represented on the ERD, including derived summaries and the result
of calculations.
A piece
of information should only be found in one place on an ERD. (*)
Which of the following can be found
in an ERD?
Instances.
Entities.
(*)
Attributes.
(*)
Tables.
The purpose of an ERD is to
document the proposed system and facilitate discussion and understanding of the
requirements captured by the developer. True or False?
True
(*)
False
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
False
(*)
Documenting
Business Requirements helps developers control the scope of the system and
prevents users from claiming that the new system does not meet their business
requirements. True or False?
True
(*)
False
Data models show users the data
that their Physical Model will contain. True or False?
True
(*)
False
A Conceptual Model is not
concerned with how the Physical Model will be implemented. True or False?
True
(*)
False
Matrix Diagrams are developed
BEFORE the ERD. True or False?
True
(*)
False
Matrix Diagrams are used to
verify that all relationships have been identified for an ERD. True or False?
True
(*)
False
Entity boxes are drawn as
Bold
Circles
Normal
Circles
Hard
Boxes
Soft
Boxes (*)
Which of the following are true
about Cardinality? (Choose two)
Cardinality
tells "how many". (*)
Cardinality
specifies whether something is required or not.
Cardinality
specifies only singularity or plurality, but not a specific plural number. (*)
Cardinality
specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
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)
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 manufactured by one or more ANIMALs.
Each
ANIMAL must be the seller of one or more FOOD TYPES.
Relationships can be either
mandatory or optional. True or False?
True
(*)
False
Relationship names are not shown
on an ERD. True or False?
True
False
(*)
When reading the relationships in an ERD, you are said to be
speaking:
Gibberish
Entity-ish
ERDish
(*)
Relationship-ish
A subtype can have a relationship
not shared by the supertype. True or False?
True
(*)
False
All instances of a subtype must
be an instance of the supertype. True or False?
True
(*)
False
All instances of the supertype
must be an instance of one of the subtypes. True or False?
True
(*)
False
Which of the following is true
about subtypes?
Subtypes
must not be mutually exclusive.
One
instance of a supertype may belong to two subtypes.
Subtypes
must be mutually exclusive. (*)
Subtypes
should not be exhaustive.
All instances of a subtype may be an instance of the
supertype but does not have to. True or False?
True
False
(*)
How would you model a business
rule that states that girls and boys may not attend classes together?
Make
the attribute Gender mandatory
Use a
supertype
Supertype
STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is
related to CLASS (*)
Make
the attribute Gender optional
A business rule such as "All
accounts must be paid in full within 10 days of billing" is best enforced
by:
Making
the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both
sides.
Creating
additional programming code to identify and report accounts past due. (*)
Making
the payment attribute mandatory.
Creating
a message to be printed on every bill that reminds the customer to pay within
ten days.
A business rule such as "We
only ship goods after customers have completely paid any outstanding balances
on their account" is best enforced by:
Making
the payment attribute null.
Making
the payment attribute optional.
Creating
additional programming code to verify no goods are shipped until the account
has been settled in full. (*)
We need
to trust our customers, and we know they will pay some day.
Can all constraints be modeled on
an ER diagram?
Yes,
all constraints must be modeled and shown on the ER diagram
No, in
which case you should let the database administrator handle them
No, and
those that cannot be modeled should be listed on a separate document to be
handled programmatically (*)
No, but
you just explain them to the users so they can enforce them
Many to many relationships between entities usually hide
what?
Uniqueness
Another
entity (*)
Another
relationship
More
attributes
If an intersection entity is
formed that contains no attributes of its own, its uniqueness may be modeled by
Creating
new attributes.
Barring
the relationships to the original entities. (*)
Placing
the UID attributes from the original entities into the intersection entity.
None of
the above.
What do you call the entity
created when you resolve a M:M relationship?
Recursive
entity
M:M
entity
Intersection
entity (*)
Inclusion
entity
One to many relationships are the
most uncommon type of relationships in an ERD. True or False?
True
False
(*)
Which of the following pairs of
entities is most likely to be modeled as a M:M relationship?
CAR and
WHEEL
TEACHER
and SUBJECT AREA (*)
TREE
and BRANCH
PERSON
and FINGERPRINT
Many to many relationships must be left in the Model. It is
important to have them documented as M-M. True or False?
True
False (*)
If the same relationship is
represented twice in an Entity Relationship Model, it is said to be:
Removable
Replicated
Resourceful
Redundant
(*)
Correct Correct
48.
If a relationship can NOT be
moved between instances of the entities it connects, it is said to be: Mark for Review
(1) Points
Transferable
Mandatory
Non-Transferable
(*)
Optional
Correct Correct
49.
Every ERD must have at least one
non-transferable relationship. True or False?
Mark for Review
(1) Points
True
False
(*)
Correct Correct
50.
A Diamond on a relationship
indicates the Relationship as Non-Tranferable. True or False? Mark for Review
(1) Points
True
(*)
False
Having your own house is the dream of every person. For a middle class person, it is considered as a lifetime achievement as it requires quite a huge amount of money. Banks play a pivotal role in fulfilling this basic need. The products they offer and the services they provide are of immense use to people who intend to have their own house. For a safe and beneficial home loan, proper awareness over the products, policies, terms and conditions of the bank is most important as ignorance may result in more payments to the bank in terms of principal and interest components.
ReplyDeleteBut working with Mr Pedro changed everything in the lending experience, Mr Pedro helped me with a home loan at 2% rate which was very fast and smooth.
I will recommend Mr Pedro a loan officer and his awesome funding company Email Mr Pedro on pedroloanss@gmail.com.
Marie Carlos,
Texas USA