Database management systems

Assignment Help Database Management System
Reference no: EM13780849

Question A  Referential integrity "rules" trigger some cleanup of your data when insertion, update, or deletion events would typically cause data anomalies. But the word "trigger" has its own place in database design and implementation. Research the concept of a "trigger" and compare and contrast "trigger" events with referential integrity rules.

Question B   Discuss the concept of the intersection table. Why is it needed in many to many relationships? Why is intersection data needed?

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.

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 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: EM13780849

Questions Cloud

Write an argumentative essay on gun control in the us : Write an Argumentative Essay on Gun Control in the United States.
Find the reliability function of the system : Suppose that the lifetime T of a system is uniformly distributed on the interval (0,B), where B is a random variable having exponential distribution with parameter lambda>0. Find the reliability function of the system.
Dvd version of the same movie through savmart : AVM, a competing studio decides to sell the DVD version of the same movie through Savmart. The manufacturing cost to AVM of a DVD is $3. Savmart retails the DVDs for $16 apiece. AVM charges a wholesale piece of $6 per DVD. Assume that the DVD demand ..
City hospital is located in the heart of a large midwestern : THE CASE: Selecting Patient Escorts City Hospital is located in the heart of a large Midwestern city. It is one of five major hospitals in the area and has recently built a small addition for treating well-known patients such as professional football..
Database management systems : Referential integrity "rules" trigger some cleanup of your data when insertion, update, or deletion events would typically cause data anomalies. But the word "trigger" has its own place in database design and implementation. Research the concept o..
Effects of global warming : What are some of the predictions of the UN Global Initiative on climate change for the effects of global warming?
What would be cost saving per hour from paying less money : A company has started a phone service that uses overseas doctors to provide emergency medical consultations. The responding doctors are based in a country with low wages but with a highly skilled pool of physicians. Responding to each call takes on a..
What are the market effects of a deadweight loss : What are deadweight losses, and what are causes - what are the market effects of a deadweight loss?
Create a power point presentation on leadership skills : Create a power point presentation on Leadership Skills For The 21st Century.

Reviews

Write a Review

 

Database Management System Questions & Answers

  List course along with names of students from database table

List the courses (D-code and C-no), along with the names of the students who are currently taking them. List all the courses (D-code and C-no) that John (i.e., S-Name=''John'') got 'A' grade.

  Bioinformatics for representing sequence annotation

The GFF3 format is a commonly-used one in bioinformatics for representing sequence annotation and which ID (cv_id) corresponds to the GO ontology stored in the database and how many controlled vocabulary terms (cvterm table) are linked to the GO onto..

  Define the database life cycle

Per the text, the Database Life Cycle includes the Database Initial Study, Database Design, Implementation and Loading, Testing and Evaluation, Operation, and Maintenance and Evolution phases.

  Validity of the collected data and include the survey report

Describe the easy and difficult aspects of creating and conducting an online questionnaire. Assess the reliability of the collected data and include the survey report. Assess the validity of the collected data and include the survey report

  Design tables in 3nf various codes for at least three fields

Create tables in 3NF. As you create the database, include different codes for at least three of the fields. Use sample data to populate fields for at least three records in each table.

  Normalized erd-memo or and database file

Normalized ERD, Memo, and Database File

  Write names and e-mail addresses showing foreign key columns

Illustrate all the data in each of four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

  Explain business intelligence and data warehouses

Business Intelligence and Data Warehouses, Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a manner that optimizes processing large amo..

  Create a database design

Create a database design (schema) based on the following problem description.

  Describe a minimum of three heuristics to optimize queries

Your supervisors and customers are very impressed with the database you have put together. Describe a minimum of three heuristics to optimize Queries.

  Create a list of managers and supervisors

Your company wants to encourage carpooling. Create an answer table listing employee name, city and street address (in that order) for employees who live in Crestline.

  Prepare a database from scratch that contains at a minimum

prepare a database from scratch that contains at a minimum the elements listed below. the kind of database you create

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