Solution-Develop a database that will maintain a customer

Develop a database that will maintain a customer list

Assignment Help Database Management System

Reference no: EM13926273

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.

Reference no: EM13926273

Questions Cloud

Problems that you have encountered in your life : What are some examples of moral problems that you have encountered in your life?(for example having to pull the plug on a loved one or telling your best friend that her husband is cheating on her with someone else)

Benefit you in the job market : No matter how you obtain a Master's degree the possibilities are endless to how it can benefit you in the job market. The online option versus the on site option both have there pros and cons. The MBA online versus the traditional MBA markets need..

What is the marginal value of a pound of pine bark : What is the marginal value of a pound of pine bark? Over what range is this price value appropriate? What is the maximum price the store would be justified in paying for additional pine bark?

What kinds of problems should shawn and his core team : What kinds of problems should Shawn and his core team anticipate early in the change process

Develop a database that will maintain a customer list : Develop a database that will maintain a customer list, a room/feature list, and rental information - You have two cots that can be added to any of the rooms for a maximum of five occupants per room.

Financial situation and plans : Summarize your financial situation and plans. Be sure to include plans for budgeting, saving, debt and credit, taxes and insurance, investing, retirement and estate planning.

Some of these resources include household surveys : Statistical measures of crime can be collected through several different resources. Some of these resources include household surveys, through hospital records, and law enforcement agencies. Once this information is gathered and reported to the FB..

Marketing mix concept by the company : Explain in detail the implementation of the 4 Ps marketing mix concept by the company, including the following:

Describe an organized crime group that flourished : Research and describe an organized crime group that flourished in the early to mid twentieth century. How might the group's role in providing assistance to the community reinforce its' ethnic makeup

User Account

All Pages

Develop a database that will maintain a customer list

Reference no: EM13926273

Reference no: EM13926273

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT