Ch05-Advanced Data Modeling
Advanced Data Modeling
Answers to Review Questions
1. What is an entity supertype, and why is it used?
An entity supertype is a generic entity type that is related to one or more entity subtypes, where the
Chapter 2 Data Models
What are business rules, what is their source, and why are they crucial?
Business rules are precisely written and unambiguous statements that are derived from a detailed
description of an organization's operatio
Test 1 Preparation
Preparation for Multiple Choice Section
A) Do Practice Quizzes on Chapters 1, 2, 3, 4, 5, and 6 posted on D2L in the Quiz section
B) Understand the following concepts:
a. Collection of programs that manages the database structur
Chapter 4 Entity Relationship (ER) Modeling
Entity-Relationship (ER) Modeling
This chapter attempts to present a fairly balanced view of Entity-Relationship Modeling. One the one
hand, a pragmatic focus on the aspects of the ERD
MIS 342 SQL Questions
1. List all employees.
2. List Customers First Name, Last Name , and Phone
SELECT FirstName, LastName, Phone
3. List first name, last name, salary and Department of all employees making more