Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

B01DBFN212 Database Fundamentals

tag 0 Download 5 Pages / 1,065 Words tag 23-07-2021

Question:

Customers make requests to hire bikes by either telephoning FBR or by simply walking into the shop. If a customer agrees to hire a bike (s) then their name, address and contact details are recorded. A customer can rent one or more bikes at a given time. For each bike that is rented a rental record is created. This contain the rental date, the time the
bike was taken out, the time it was due back and the actual time it was returned. In addition,the amount of rent paid is recorded which is determined through the class size code. Each rental record is associated with only one customer. A bike can be rented out any number of times or may never be rented.

Complete the following tasks:
1. Create a complete ERD to support the business needs as described above
2. Convert the ERD in at least 3NF and draw a dependency diagram
3. Create a database for FBR using MS ACCESS (Create tables only for bikes, rentals and customers with primary and foreign keys defined and other their other data)
4. Create a form to input data for bikes.
5. Input some significant data (8 bikes, 5 customers and 4 rentals)
6. Create SELECT, JOIN and NUMERIC Function queries (one of each type; you can use any tables and any fields)
7. Create a report using any one of the above queries. 
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 5 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Database Fundamentals. Retrieved from https://myassignmenthelp.com/free-samples/b01dbfn212-database-fundamentals/rental-record.html.

My Assignment Help (2021) Database Fundamentals [Online]. Available from: https://myassignmenthelp.com/free-samples/b01dbfn212-database-fundamentals/rental-record.html
[Accessed 02 December 2022].

My Assignment Help. 'Database Fundamentals' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/b01dbfn212-database-fundamentals/rental-record.html> accessed 02 December 2022.

My Assignment Help. Database Fundamentals [Internet]. My Assignment Help. 2021 [cited 02 December 2022]. Available from: https://myassignmenthelp.com/free-samples/b01dbfn212-database-fundamentals/rental-record.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?