Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

Assignment 2 S3-2015 CIS5200 Baig 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 Draw a zero level diagram for the new system for Baig’s Auto Rental business Task 3 Draw an ERD for Baig’s Auto Rental business indicating the types of relationships between the entities. (30%) Task 4 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. (25%) Task 5 Create fully normalized 3NF table designs for the system. (25%) Task 6 Suggest ways Baig’s Auto Rental business can use codes to simplify output, input, and data formats. (20%)



testimonials icon
Running head: INTERNATIONAL MARKETINGInternational MarketingNameInstitutional Affiliation1INTERNATIONAL MARKETING2International MarketingPart I: Glob...
testimonials icon
You have been subcontracted as an IT consultant by your employer, or a firm you are familiar with, to prepare a study report about the com...
testimonials icon
I will be off line till after 8 PM EST July 9th.  Please review the essay requirements below.  Please provide a short sample of your...
testimonials icon
  Assignment Content Create the Final Strategic Plan. The Final Strategic Plan contains the elements of all the previous weeks’ component...
testimonials icon
You have chosen a country for the Walmart Case Study. International Logistics Services (ILS) has acquired a new warehouse...
testimonials icon
Question1What is good religion? What is true religion?Definitions of whether a religion is true or good tend to be a bit problematic: For exa...
testimonials icon
Kim was walking down a rocky path. For minutes, the elevation dropped steadily. Altogether it the change it dropped 8 feet. What was the change in ele...
testimonials icon
Post between 200 and 300 words....
testimonials icon
ACC 561 Accounting Week 2 Practice Quiz...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65