Show the primary and foreign keys for each entity

Assignment Help Basic Computer Science
Reference no: EM131012160

Cars-To-Drive (CTD) is a used car dealership operating in the Sydney CBD as a franchise business. They wish to have their customers to be able to view the cars listed for sale online and to track what cars are being sold and what other cars are in stock by each franchisee.

CTD has hired you to design a relational database to better track and record their operational data, according to the business rules listed below:

1. CTD dealers exist in six different locations around the Sydney area and each location has just one dealer, being the franchisee.
Every location is identified by a location code, location name, street, city, state, postcode and phone number. Similarity, a franchisee is identified by a number, name, contact, etc...

2. A franchisee employs between 4 to 8 staff members in each location and one of these employees is the manager who supervises all other staff/employees.
Information about all the employees and the manager in each location is to be kept in the database.

3. Each location stores various types of cars, and each type may contain a range of the same type; for example a type is Commodore and a range is Commodore Calais-V, a Commodore Evoke, etc., but each range is of only one type.
Information about all the car type, range, year, and condition in each location is to be kept in the database.

4. CTD needs to also record the cars that were sold by each franchisee: the type and range, the date sold and the salesperson who sold the car. Accordingly a franchisee may sell many cars of the same type and range.

· Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.

· Clearly show the primary and foreign keys for each entity.

Reference no: EM131012160

Questions Cloud

Conduct a management analysis of haighs chocolates : Conduct a management analysis of Haigh's Chocolates - Research, analysis and discussion of sustainability related strategies and issues
Riskier divisions get a greater share of capital : If the overall company weighted average cost of capital (WACC) were used as the hurdle rate for all divisions, would more conservative or riskier divisions get a greater share of capital? Explain your reasoning.
Which ecological system does the following describe : Which ecological system does the following describe? The teacher of a child with diabetes communicates with the parents about the child's needs
How much will you receive when the bonds mature : You purchase 6,500 bonds with a par value of $1,000 for $981 each. The bonds have a coupon rate of 10.4 percent paid semiannually, and mature in 10 years. How much will you receive on the next coupon date? How much will you receive when the bonds mat..
Show the primary and foreign keys for each entity : Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.
What are the different types of financial intermediaries : What are the different types of financial intermediaries? Give some characteristics that differentiate the various types of intermediaries. Describe the banking system found in the United States. What role does the Federal Reserve play in the U.S. ba..
Through its open market operations : Through its open market operations, the Federal Reserve recently increased deposits at financial institutions by $80 billion. If the reserve requirement for all deposits is 8 percent, what is the maximum effect that the Fed’s actions can have on tota..
What is the percentage reserve requirement : Deposits in all financial institutions equal $2 trillion. The total reserves held by these institutions are $200 billion, $100 billion of which is in excess of reserve requirements. What is the percentage reserve requirement?
Define the first step of research : Write a one to two (1-2) page essay in which you: Identify the first step in the student's guide to research.  Define the first step of research in your own words. Identify the major assumptions and bias of the drug industry that underlie drug resear..

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Ieee 754-floating point representation

Express the final answer in single precision IEEE 754-floating point representation - In single precision IEEE 754-floating point numbers, perform the subsequent operations.

  Support day-to-day working activities of organization

____are used to support day-to-day working activities of organization. Typical decisions involve e-commerce transaction acceptance, approval of personal loans by bank.

  The envirofacts data warehouse

The Envirofacts Data Warehouse

  Conduct research on the types of computer networks

Conduct research on the types of computer networks

  Making it eco-friendly

When you hear the term "making IT eco-friendly", explain how this is related to Information Technology and the environment.

  Develop an original and unique scenario to describe

With regards to risk-response planning, there are four (4) responses to negative risks that an organization may pursue: avoid, transfer, mitigate, and accept. Develop an original and unique scenario to describe and contrast each of these respo..

  Three json data files storing tweets collected

The description of assigned tasks has been given in details in the assignment notebook. You are required to follow the instructions in the notebook to complete your tasks. 3. Submission Instruction

  How many threads will you create to perform the input

How many threads will you create to perform the input and output and how many threads will you create for the CPU-intensive portion of the application

  The provided assignment submission attach file

Screenshot File Submission: You must submit the screenshot file(s) using the provided Assignment Submission Attach File function located in the Blackboard online course shell. To access Assignment Submission Attach File function, you must select the ..

  Calorie management

Option 1: Calorie Management Develop an algorithm in pseudocode that shows the tasks and subtasks for each program module component that was in the simple algorithm you developed in Week 2

  What is primary security risk users acknowledge using macros

Write a 200- to 300-word response that answers the following question: Based on the article by Lenning (2005), what is a primary security risk that users should acknowledge when using macros?

  Riordan manufacturing

A full description of the new system, a description of its components, and the benefit it will provide to Riordan Manufacturing (Virtual Organization)

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