IT 203_Week02_Homework

IT 203_Week02_Homework - includes Order ID (primary key),...

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

View Full Document Right Arrow Icon
IT 203 Trinity Martin Week 02 Homework A. The items being modeled by a relational database are known as ____________. a. attributes b. entities c. keys d. relationships B. Each doctor can see multiple patients. A patient can visit any doctor at the clinic. This describes what type of relationship? a. One-to-one b. One-to-many c. Many-to-many d. Cannot tell from the information given. C. What is used as a visual model of entities and their relationships? a. ERD b. Constraint c. Key d. Tuple D. You are designing a table to store employee records. Which should you use as the primary key? a. Last name b. Address c. First and last name d. Social security number E. You need to create a relationship between the Employee entity and Order entity. The Employee entity includes EmployeeID (primary key), First name, Last name, and e-mail address. Order entity
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: includes Order ID (primary key), EmployeeID, and date. What should you do? a. Define EmployeeID in the Employee entity as a foreign key. b. Define OrderID in the Order entity as a foreign key. c. Define EmployeeID in the Order entity as a foreign key. d. Add EmployeeID to the Order entity primary key. F. It is necessary to define an associative entity when defining _________________. a. any relationship b. a one-to-one relationship c. a one-to-many relationship d. a many-to-many relationship G. Which type of database management system uses physical pointers to connect tables? a. Hierarchical b. Network c. Relational d. Object-oriented H. The information used to describe an entity is known as ________________. a. attributes b. key c. tables d. relationships...
View Full Document

This note was uploaded on 07/26/2011 for the course IT 203 taught by Professor Accampo,e during the Spring '11 term at ITT Tech Pittsburgh.

Page1 / 2

IT 203_Week02_Homework - includes Order ID (primary key),...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online