Reference no: EM13712408
The Sailing bed and breakfast club started back in late 1980s. The goals of the club are efficiently provide cheap accommodation on the beaches in the bay for members and to provide a structure to allow members to socialize and network. To enable the members rate to remain low the bed and breakfast are available for the general public to use at higher rates.
What the club needs is something that will allow the booking officer to record all details of a booking accurately and quickly. They should be able to print this out as an invoice, which can post or email prior to the booking. The booking should then be capable of being transferred to a list containing all the bookings for that week. This list should allow the booking officer to quickly judge who can be accommodated and who can't. Finally the list needs to be capable of being quickly communicated to the relevant caretaker.
Therefore, the Database system you will develop (Assignment 2 Part B) should contain
1. A login screen
2. A switchboard with welcome message and menu to open forms and reports.
3. A data entry form to record
a. Current accommodation costs and arrangements (Master data)
b. All details of a booking (First
Name,Surname,Members(Yes/No),Address,Suburb,Postcode,Phone,B&B
Location(Required),Arrival Date,Departure,No. of Adults,No. of Children)
c. A button to calculate Total cost of booking
4. Multiple reports (You must create queries for each report)
a. An invoice, contain details and cost of the booking
b. A list, containing all the bookings for that week group by B&B Locations.
|
What is the electric potential energy of the pair of charges
: A point charge q1 is held stationary at the origin. A second charge q2 is placed at point a and the electric potential energy of the pair of charges is +7.0 x 10-9 J. What is the electric potential energy of the pair of charges
|
|
Are there any hidden assumptions or price rigidities
: 1. Are there any hidden assumptions or price rigidities in the country or countries that might inhibit market force indicators from revealing the true economic health of the country, thereby either preventing government policy actions from corr..
|
|
Where the free-fall acceleration is one-sixth that on earth
: A bag of sugar weighs 5.00 lb on Earth. What would it weigh in newtons on the Moon, Where the free-fall acceleration is one-sixth that on Earth
|
|
One year ago hp corporate bonds with 8 year maturity
: One year ago HP corporate bonds with 8 year maturity purchased at 98.1,annual coupon rate 2.65%,price sold at today 99.75,we have collected all interest payments in this one year. total return of Investment? and what type of return is it? expe..
|
|
Calculate total cost of booking
: What the club needs is something that will allow the booking officer to record all details of a booking accurately and quickly. They should be able to print this out as an invoice, which can post or email prior to the booking - switchboard with we..
|
|
Evaluate the magnitude of the force
: A 50kg box is pulled at uniform speed along a horizontal floor by a force parallel to the floor. The coefficient of friction is 0.3. Find the magnitude of the force
|
|
What is the maximum force that can be applied
: A 2.0 kg block sits on a 4.0 kg block that is on a frictionless table. What is the maximum force F that can be applied to the 4.0 kg block if the 2.0 kg block is not to slide
|
|
Determine distance travelled by each rock
: Consider three spherical rocks having diameter of 10 cm (A), 20 cm (B), and 40 cm (C). The densities of these rocks are given to be 2,500 kg/m3. They were left to free-fall above a water stream having a uniform velocity profile (um=0.1 m/s). The stre..
|
|
The company has a target capital structure of 50 percent
: Southern Alliance Company needs to raise $23 million to start a new project. The company will generate no internal equity for the foreseeable future. The company has a target capital structure of 50 percent common stock, 8 percent preferred st..
|