{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Week 4 Written Homework - 1 Match the type of Unique...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1. Match the type of Unique Identifier to the entity. a. Simple UID b. Composite UID c. Composite UID comprising an attribute and a relationship d. Primary Key & Secondary Key D C B A 2. Describe how you would identify the entities listed 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. a. A city – comprised of Composite UID: location, name of city b. A contact person for a customer – comprised of Artificial UID Primary Key: customer number Secondary Key: address Composite Secondary Key: first name, last name c. A train – UID comprised of: Artificial Primary Key: train number Secondary Key: location, size d. A road – UID comprised of: Artificial Primary Key: road number Composite Secondary Key: state, city 3. When checking a database model for first normal form, what are you doing exactly?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}