Draw a context diagram for the new system for Baig’s Auto Rental business.

atabase Notmalization

I NEEDED THE ASSIGNMENT IN NEXT 12 HRS 

DATABASE

 

AutoParts Warehouse

 

Baig’s Auto Rental is a rental business with several locations in several areas of Brisbane and around Brisbane metro areas. The business is based on the idea of discount prices for their vehicle rental products that are always in stock or can be delivered within hours if available form other location of the business. The owners have decided to computerize their operations to allow them to better track their business and manage their inventories for just in time deliveries for sales. Data to be gathered for each customer sale includes invoice number, date, vehicle registration number, vehicle type, customer history, vehicle history, rental price per day, rental price per week. Customer data is collected that includes basic contact information and vehicles owned, which includes vehicle make and model. For vehicle that have to be delivered to the store to fulfill a customer purchase, a transfer request is created. Data associated with these transfers include tracking number, invoice number, date, vehicle registration number, origination location (Rental office ) number, destination Rental office number.

 

Assignment 2 Task 1

 

Draw a context diagram for the new system for Baig’s Auto Rental business

 

 

Task 2

 

For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys.

 

Task 3

 

Create fully normalized 3NF table designs for the system.

 

Task 4

 

 

Suggest ways Baig’s Auto Rental business can use codes to simplify output, input, and data formats.

Answer

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]