Management homework. kindly help

CnfpnyZ
timer Asked: Apr 25th, 2017

Question Description

In this assignment, you will briefly explain what databases are, describe the history of database management systems, list the various database architectures, and explain data normalization, including the “normal forms” and why they are needed. You will then create and populate a small normalized database in MS-Access that will schedule and track payments for a small inn.You have eight rooms in the inn. Two have two double beds, five have two queen beds, and the suite has a king bed with sleeper sofa in the living room. You have two cots that can be added to any of the rooms for a maximum of five occupants per room. The cost for the rooms are: $95/night for the doubles, $105/night for the queens, and $125/night for the suite. There is a $25/night additional charge for the cots. Develop a database that will maintain a customer list, a room/feature list, and rental information.

You should also create and print at least one report showing the customers and rooms for any given month.

You will need at least three normalized tables and ten or more customers to do this project correctly.

(Alternatively, you may create a project that contains data on something of interest to you, but it needs to include at least three tables and must be approved by me before you start work on it.)

General Instruction for Written Assignments

Your written assignment is intended to test your understanding of important concepts and discover how to sharpen your intellectual skills of analysis, synthesis, evaluation, and application. The intent of the written assignment is to provide an opportunity to more fully describe, explain, and analyze the books and other sources.

Throughout this course, there are four main resources that you can rely on that will enable you to successfully complete written assignments:

  1. Empire State College's Library and Research Resources - link here for the web-based on-line Library's home page that can be reached any time of day or night.
  2. Writing Resource Center - link here for access to writing resources developed by Empire State College and the Genesee Valley Center Writing Program.
  3. Empire State College's Writer's Complex - link here for writing tips and assistance.
  4. Research Tips for Distance Learning Students - link here for recommended resources for distance learners.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors