Entity
Question 81 / 1 ptsTheis a candidate key that is selected by the database designer to beused as an identifying mechanism for the whole entity set.
Get answer to your question and much more
Question 91 / 1 ptsare entities that provide more information about another table.Question 101 / 1 pts___________________ are the rules that force DBMSs to check that data satisfies thesemantics.
Get answer to your question and much more
Question 61 / 1 ptsare attributes that contain values calculated from other attributes.Question 71 / 1 ptsArelationship is the relationship of one entity to only one other entity,and vice versa.
Get answer to your question and much more
Question 111 / 1 ptsChoose the unique identifier for the entity listed below:STUDENT COURSE ( Student ID, Course ID)Student ID and Course IDCourse IDStudent IDnone of theseQuestion 121 / 1 pts_______________ is used when you need to obtain information based on two relatedtables.Question 131 / 1 ptsIdentify if the given description can be categorized as a Structural Business rule,Procedural Business rule or Programmatic Business rule.The Rental amount in RENTAL is calculated from the Rental rate multiplied by thenumber of days.ProceduralProgrammaticJOIN
StructuralQuestion 141 / 1 pts______ entities depend on other tables for their meaning.Question 151 / 1 ptsIdentify if the given description can be categorized as a Structural Business rule,Procedural Business rule or Programmatic Business rule.A machine operator may not work more than 10 hours in aday.Question 161 / 1 ptsBoth _________ and foreign keysmust be of the same data type.Question 171 / 1 ptsBased on the the scenario below, select the answer that is an ATTRIBUTE:
A customer owns several shopping carts. A shopping cart is identified by aShopping_Cart_ID and contains several books. Some shopping carts may containmore than one copy of same book. The database records the number of copies of eachbook in any shopping cart. At that time, more information will be needed to complete thetransaction. Usually, the customer will be asked to fill or select a billing address, ashipping address, a shipping option, and payment information such as credit cardnumber. An email notification is sent to the customer as soon as the order is placed.
Get answer to your question and much more
Question 181 / 1 ptsThedata model has existed for over 35 years.Question 191 / 1 ptsAn attribute or group of attributes whose values can be used to uniquely identify anindividual entity in an entity set is called a(n) _______________.Question 201 / 1 ptsComplete the business rule for the following scenario:A customer owns several shopping carts. A shopping cart is identified by aShopping_Cart_ID and contains several books. Some shopping carts may containentity relatiokey
more than one copy of same book. The database records the number of copies of eachbook in any shopping cart. At that time, more information will be needed to complete thetransaction. Usually, the customer will be asked to fill or select a billing address, a
Upload your study docs or become a
Course Hero member to access this document
Upload your study docs or become a
Course Hero member to access this document
End of preview. Want to read all 86 pages?
Upload your study docs or become a
Course Hero member to access this document
Term
Spring
Professor
N/A
Tags
