Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Jul 2017 |
Last Sign in: | 231 Weeks Ago, 3 Days Ago |
Questions Answered: | 15833 |
Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
Please answer the following questions pertaining to data management EDR d
Question 1
Which of the following best represents a multi-valued attribute?
Question 1 options:
A) A person's name
B) A person's GPA [grade point average]
C) A person's social security number
D) A person's favorite foods
Question 2
Garden Glory is a company that provides yard maintenance services to its customers. Garden Glory offers many types of services such as grass cutting, shrubby maintenance, flowering planting, trimming, etc. Many of its customers have multiple properties [houses, office buildings, apartment complexes] that require gardening and lawn maintenance services. Garden Glory wants to maintain data on customers, properties, services offered and also track services provided. For services provided, they want to know what property, who that property belongs to and what services the property receives.
Which of the following represent entities for this scenario. THERE MAY BE MORE THAN ONE ANSWER.
Question 2 options:
[] Type of property such as apartment complex [] Type of service such as grass cutting
[] City [] Customer Last Name [] Property
[] Service Tracking [] who the property belongs to
[] Street Address [] Yard Service [] Customer
Question 3
Garden Glory is a company that provides yard maintenance services to its customers. Garden Glory offers many types of services such as grass cutting, shrubby maintenance, flowering planting, trimming, etc. Many of its customers have multiple properties [houses, office buildings, apartment complexes] that require gardening and lawn maintenance services. Garden Glory wants to maintain data on customers, properties, services offered and also track services provided. For services provided, they want to know what property, who that property belongs to and what services the property receives.
Which of the following represent attributes for this scenario. THERE MAY BE MORE THAN ONE ANSWER.
Question 3 options:
[] Type of service such as grass cutting [] Service Tracking [] Customer
[] Who the property belongs to [] Customer Last Name [] Yard Service
[] Property [] Street Address [] City
Question 4
Given the following scenario, choose the best ERD diagram.
An employee may manage many employees or may not manage any employee. Every employee is managed by one and only one employee.
Question 4 options:
A) ER Diagram A
B) ER Diagram B
C) ER Diagram C
D) ER Diagram D
Question 5
Given the following scenario, choose the best ERD diagram.
An actor can perform in many plays. A play can have many actors.
Question 5 options:
A) ER Diagram A
B) ER Diagram B
C) ER Diagram C
D) ER Diagram D
Question 6
What is the identifier of the displayed entity?
Question 6 options:
A) First Name
B) KSU ID
C) Last Name
D) ZIP
Question 7
What is the identifier of the displayed entity?
A) Section Number
B) Course Name and Section Number
C) Course Name
D) Course Name and Student Name
Question 8
What type of relationship does the displayed ER Diagram represent?
Question 8 options:
A) Unary
B) A strong -weak entity
C) Supertype-subtype
D) Many to Many mandatory
Question 9
The displayed diagram would be read as which of the following statements?
Question 9 options:
A) Students are never assigned a parking space.
B) A student is assigned a specific parking space and a parking space is assigned to a specific student.
C) A student may be assigned a parking space and a parking space might be assigned to a student.
D) A student may park in many different parking spaces and parking spaces can be designated for students.
Question 10
Which statement best represents the model shown in the following ER Diagram
Question 10 options:
A) A salesperson must have customers assigned to them but a customer does not need to be assigned to a salesperson.
B) A salesperson must have customers assigned to them and a customer has to be assigned to a salesperson.
C) A salesperson may have many or no customers assigned to them. A customer must be assigned to a salesperson.
D) A salesperson may or may not have customers assigned to them and a customer may or may not be assigned to a salesperson.
Question 11
Match the following relationships to those depicted in the ER Diagram displayed.
Question 11 options:
|
|
Question 12
The displayed ER Diagram represents a Non-identifying (non id dependent) relationship.
Question 12 options:
A) True
iagrams
Attachments:----------- ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly