The new database solution to address the current state

Assignment Help Operation Management

Reference no: EM132128495

Scenario:

You will be developing your submissions (a relational database model, and plan for implementation) around the following scenario: Birchwood Lane Schools currently records all student, instructor, and course data on paper. To meet state and federal requirements, Birchwood Lane Schools must implement an application system that records all student, course, and instructor data electronically. You will design a DBMS model and develop a strategy for implementation, which you will flesh out in a comprehensive written report.

Current data needs include the following:

1. Student data (full name, full address, phone, email, birthdate, enrollment date, graduation date, courses taken, courses currently enrolled)

2. Instructor data (full name, full address, phone, email, birthdate, hire date, courses taught, courses currently assigned)

3. Course data (course name, course start date, course end date, course category, instructor, students)

Questions:

II. Business Case and Gap Analysis: Analyze the client needs and how the project will address them. This type of analysis identifies the difference between a current condition and future state (i.e., gap analysis). Based on the scenario showing the current system that the school has in place to collect data:

A. What information should be included in the new database solution to address the current state? Why?

B. What additional information is needed to complete the business case data requirements and achieve the desired future state?

Reference no: EM132128495

Questions Cloud

What is the probability that you would see a sample mean : Suppose you somehow knew that the true mean per-student expenditure was $215. What (approximately) is the probability that you would see a sample mean.

Gatekeeper or voip server in a voip deployed network : Discuss the importance, functionality, and role of a GateKeeper or VoIP server in a VoIP -deployed network?

How many tankfuls must you sample in a future test : After you turn in your report, you regret not having been able to make more confident statements about the validity of the manufacturer's claim.

Advantages and problems of using bitmap index structure : Taking this cube as an example, briefly discuss advantages and problems of using a bitmap index structure.

The new database solution to address the current state : What information should be included in the new database solution to address the current state? Why?

Advantage of using the dialog box over setting various : On Microsoft word, what would be the advantage of using the dialog box over setting various tabs directly on the ruler line?

Board mean on the iss governance qualityscore : What does a score of 9 under "board" mean on the ISS governance QualityScore?

Determine how big should your sample be : Suppose we wanted to conduct a survey. It is desired that we produce an interval estimate of the population mean that is ±5 from the true population mean.

Identify value chain strategies for manufacturing : Examine and discuss competitive strategies that manufacturers can use to gain competitive advantage.

User Account

All Pages