Construct relational database for new yorks fire departments

Assignment Help Database Management System
Reference no: EM131143421

Be sure to normalize the data tables for both databases to 3NF

You may submit a single Word document with your models pasted in or as separate PDF files representing each model.Be sure to normalize the data tables for both databases to 3NF

You may submit a single Word document with your models pasted in or as separate PDF files representing each model.

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:

• SalespersonNumber (unique), SalespersonName, 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 firefighter 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: EM131143421

Questions Cloud

Social responsibility in its overall corporate strategy : Starbucks’s Mission: Social Responsibility and Brand Strength (pages 396-403) Starbucks’s Global Responsibility Report Over the past 30 years, Starbucks has worked to expand nationwide, and even internationally. Why do you think Starbucks has been so..
Write research paper on one of the given topics : For discussion activity, consider a topic and research on that topic. - Describe whether you would choose a quantitative, qualitative, or mixed-methods method to approach the topic.
Determine the flying height of the camera at the time : Using photo coordinates for points 4 and GYM on image 5, determine the flying height of the camera at the time of exposure.
Differentiate operational development from change programs : Explain Operational Development and differentiate operational development from other change programs? Provide and example of satisficing?
Construct relational database for new yorks fire departments : Construct a relational database for New York's fire departments and firefighters. 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.
Determine the scale of the photo : Using photo coordinates for points 4 and GYM on image 5, determine the scale of the photo.
Role fedex managers play in facilitating team effectiveness : How do the standards set by Fred Smith for FedEx teams improves organizational performance? What motivates the members of FedEx to remain highly engage in their teams? Describe the role FedEx managers play in facilitating team effectiveness? What typ..
How a criminal charge is filed the pre-trial process : For this assignment, you will examine constitutional protections for defendants prior to trial by providing a detailed analysis of the criminal justice process from arraignment to the setting of a trial for a defendant. At a minimum, your paper mu..
What wavelengths produce the colors blue green and red : To what wavelengths of electromagnetic energy is the human eye sensitive? What wavelengths produce the colors blue, green, and red?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Query using a literal character string

query specifying specific columns query using a column alias query using the concatenation operator query using a literal character string

  Design relational database using entity-relationship diagram

Design a Relational Database using Entity-Relationship Diagram (ER-D) and design a Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models.

  Prepare database design using the data definition

Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

  Question 1a explain the use of facts dimensions and

question 1a explain the use of facts dimensions and attributes in a star schema model.b in relation to a fact table

  Create table command, and modify it to create a new table

Start with this CREATE TABLE command, and modify it to create a new range_partitioned table named CH07EMPLOYEE_RANGE that contains the same column as the employee table.

  Create and print a select query that lists the book title

Create and PRINT a select query that lists the book title and List Price for all book title startwith Life. Save this query as KellyCaseC before you print it

  Describes the basics of database planning

The link should be to an informative piece that describes the basics of one of the following: Database Planning, SQL, Access 2010, Queries and Form Design

  Write short notes on erd and database file

This course utilizes the Virtual Organizations, an Apollo Group, Inc. learning tool. The Virtual Organizations portal is accessed from the link on your course materials page.

  Provide the sql code that inserts data into all of the table

Provide the SQL code that inserts data into all of the tables

  Create three tables as per specifications

COMP 108 Introduction to Databases - Pulling it All Together - Dentist's Office. Step by Step Description: Use all of the naming conventions discussed in this course. Create three tables as per specifications above with the proper formatting

  Consider a relation stored as a randomly ordered

Consider a relation stored as a randomly ordered ?le for which the only index is an unclustered index on a ?eld called sal. If you want to retrieve all records with sal > 20, is using the index always the best alternative? Explain.

  Entity-relationship modelling techniques

Give you practical experience in using Entity-Relationship and Relational Database modelling techniques.

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