Management homework. kindly help
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:
- 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.
- Writing Resource Center - link here for access to writing resources developed by Empire State College and the Genesee Valley Center Writing Program.
- Empire State College's Writer's Complex - link here for writing tips and assistance.
- Research Tips for Distance Learning Students - link here for recommended resources for distance learners.
This question has not been answered.
Create a free account to get help with this and any other question!
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