Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 2 6-1 Question 2 Consider an entity for Library Member. Sometimes an entity can have more than one can-didate UID. Describe a scenario where
QUESTION 2 6-1 Question 2 Consider an entity for Library Member. Sometimes an entity can have more than one can-didate UID. Describe a scenario where you would want more than one candidate UID for a Library Member - why would you want to find the member in the database using alterna-tive information? QUESTION 3 6-1 Question 3a Describe how you would identify the entity below, making up any attributes and relationships you consider appropriate. For example, for the Student entity you may say that the UID is comprised of the first name, last name, and address. Or you might suggest that the Student entity contains an artificial UID called student number. City QUESTION 4 6-2 Question 1 When checking a database model for first normal form what are you doing exactly? QUESTION 5 6-2 Vocab Match the vocabulary word for each definition A. Normalization The outcome of the first step of database normalization. 1NF eliminates repeating groups by putting each into a separate table and connecting them with a 1:M relationship B. First Normal Form (1NF) A series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redun-dancy and the chances of data becoming inconsistent QUESTION 10 8-1 Question 1 In the scenario below, what words or phrases indicate to you the need to track data that changes over time? Actors at the local theater sign contracts that specify their pay and working conditions. These contracts are renewed annually. Each year the contracts may change through new language and pay rates. In order to resolve labor disputes, the theater must sometimes go back several years in order to see the contract provisions in place on a particular date
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started