Construct a relational database for leslies auto sales

Assignment Help Database Management System
Reference no: EM131336758

1. Leslie's Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it sells. Each of these three entity types has a unique attribute identifier.

The attributes that it stores are as follows:

• Salesperson Number (unique), Salesperson Name, Salesperson Telephone, Years with Company.
• Customer Number (unique), Customer Name, Customer Address, Value of Last Purchase From Us.
• Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price Leslie' s also wants to keep track of which salesperson sold which car to which customer, including the date of the sale and the negotiated price. Construct a relational database for Leslie's Auto Sales.

2. The State of New York certifies firefighters throughout the state and must keep track of all of them, as well as of the state's fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique fire-fighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieutenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter's supervisor. Supervisors are always higher-ranking certified firefighters.

Construct a relational database for New York's fire departments and firefighters.

Reference no: EM131336758

Questions Cloud

Cultural and ethical differences-discussion : Ethical lapses are often confused with ethical dilemmas! In application, these are two very different things. An ethical lapse is a failure to behave in an ethical way in some specific situation, while an ethical dilemma is a situation in which no..
What total amount of dividends should lenberg pay : If Lenberg has $6 million of investment projects having expected returns greater than 12 percent, what total amount of dividends should Lenberg pay?
What factors you cite that might account for the phenomenon : What do you suggest as an optimal dividend policy for both Phoenix and Denver that might lead to increases in both of their share prices? What are the limitations of your suggestions?
Business information systems : 1. Discuss the differences between data, information, businesses intelligence, and knowledge in relation to a business. Include how the component of people fits into this mix.
Construct a relational database for leslies auto sales : Vehicle Identification Number, Manufacturer, Model, Year, Sticker Price Leslie' s, including the date of the sale and the negotiated price. Construct a relational database for Leslie's Auto Sales.
Electrical or optical transmission systems : What is the movement of computer information by means of electrical or optical transmission systems?
Analyse costs in business organisations contexts : Managerial Accounting - BLB00045-5 - Analyse costs in business organisations contexts - Apply cost estimation techniques in a range of business situations and Effectively communicate cost and revenue information in a decision making context
Forced distribution will increase customer satisfaction : 1. Do you predict that the forced distribution will increase customer satisfaction? Why or why not? 2. Which clerical workers do you think will most strongly oppose the change? 3. How do you think supervisors will react to the proposed change?
Finance the expansion with externally raised equity : Finance the expansion with 50 percent externally generated equity and 50 percent internally generated equity. This alternative would necessitate a dividend cut for this year only.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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