Agenda and Objectives

1. Agenda and Objectives • Agenda • Practice creating normalized data models • Objectives • Given a scenario or business rules, you will be able to develop a 3NF relational data model • Resource • Data_Modeling_Practice_STUDENT.pptx

2. Data Modeling Practice IS 310Dr. Jean A. Pratt

3. Business Rules for Employee Employee:Department • A department employs one or more employees. • Each employee works in one department. Employee:Children • An employee could have many children. • Each child is related to one or more employees. Employee:Phone • An employee has one or more phone numbers on file. • Each phone number refers to one employee. Employee:Address • An employee lives at one address. • An address is the residence for one or more employees.

4. Business Rules for Mtc Business Equipment:Maintenance • A maintenance task is performed on many pieces of equipment. • A piece of equipment can have many maintenance tasks performed on it. Client:Service • A client receives many services. • Each service is provided to many clients. • We provide snow removal in the winter and landscaping during the summer. • We don’t track which equipment was used on which jobs, since we use the same equipment on almost all similar jobs (e.g., snowplow, rake, lawnmower). Client:Payment • A client makes one or more payments. • Each payment is made by one client. • Clients can pay annual fee rather than per service performance.

5. Scenario: Publication Database You work for a publisher who wants to track which books were written by which authors, and the order of the author (e.g., 1, 2, 3 representing first, second or third author). Other data we need for the books is the date they were published, the type of cover (hard or soft), the number of pages, and the genre. For each author, we need basic contact information, including mailing, phone and email.