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

Reviews

Write a Review

Database Management System Questions & Answers

  Create database objects to track the construction projects

You will use a database template to enter data into the Events table. You will create a simple query, a form, and a report.

  Identify the potential sale and department store transaction

Evaluate whether the use of a distributed DBMS structure is appropriate and identify the optimization techniques that should be factored in to enhance the operations of the database in your design.

  Compute the activity rates for the installing floors

Compute the overhead cost, according to the activity-based costing system, of a job that involves installing 3.2 squares - Prepare the first-stage allocation of overhead costs

  Explain how big is a single interval in volts

How big is a single interval in volts. Receivers have no choice but to decode the the binary sample value at the center of the interval. So, what would the received voltage of the sample be

  Convert this eer diagram to relational database schemas

Show an alternative design using the General notations for the attribute described in Problem 2 that uses only entity types (including weak entity types if needed) and relationship types.

  Explain the different oracle data dictionary views

Explain the different Oracle data dictionary views

  Map the eer schema into a set of relations

Map the EER schema into a set of relations. For the VEHICLE to CAR/ TRUCK/ SUV generalization, consider the four options presented

  Draw a complete entity relationship model

Discuss any FOUR reports that would be generated from the data model - Draw a complete Entity Relationship (ER) model using data model notation that you are familiar.

  Explain and design an mssql solution for high availability

Explain and design an MSSQL solution for high availability

  Database and data warehousing design

Database and Data Warehousing Design

  Design a simple form for user creation

Design a Simple form for User Creation a) With username and two passwords. b) Where both the username and password should contain at least 6 characters

  Make a select query with a calculated field for age

Make a select query with a calculated field for age,  to list only guests between 20 and 40 years of age! Make sure to enter a range of ages in your table so you have something to display.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd