Course Hero Logo

Question 6 1 1 pts are attributes that contain values

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 23 - 28 out of 86 pages.

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.
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.
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.
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.
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

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture