Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 9 For Linux UNIX And Windows Advanced Database Administration Certification Certification Study Guide

Authors: Roger E. Sanders, Dwaine R Snow

1st Edition

1583470808, 978-1583470800

More Books

Students also viewed these Databases questions

Question

understand the key issues concerning international assignments

Answered: 1 week ago