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.