Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Northern Star Skiing is a fifteen year old company that offers cross-country ski instruction and sponsors crosscountry tours in the Cascade Mountain Range. The owner,

image text in transcribed
image text in transcribed
Northern Star Skiing is a fifteen year old company that offers cross-country ski instruction and sponsors crosscountry tours in the Cascade Mountain Range. The owner, Lynn, wants to keep better track of the various Ski Courses that they offer. The various ski course consists of five days of instruction, and are staffed by 5 paid instructors and 5 unpaid apprentice instructor. The students live and eat at the lodge during the course. Following is a set of forms and reports currently used by Lynn. Follow the procedure described in Chapter 6 page 181 and 182 of the Pratt Database Concepts Book to draw the Entity Relationship diagram and transform it into relational tables for each view. For each T\\i'iew, complete an ER Diagram, Field List using DBDL, a brief Technical Summary explaining your View. After completing each view, then combine each view into a conceptual (cumulative) design. Use DBDL to describe the resulting database along with the combined ER diagram. What to Submit: For each View, submit an ER Diagram, Field List using DBDL, a brief Technical Summary explaining your view. For the Cumulative (Combined) design, submit an ER diagram, Field Lists using DBDL, a brief Technical Summary. View 2 This form is used when instructors check out equipment at the beginning of the season. Instructors often need a varied array of equipment throughout the entire

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

MIS Essentials

Authors: David M Kroenke

1st Edition

0136075606, 9780136075608

More Books

Students also viewed these General Management questions

Question

1. Build trust and share information with others.

Answered: 1 week ago