To analyse and comprehend a provided er diagram

Assignment Help Database Management System
Reference no: EM13312094

Objectives:
• To analyse and comprehend a provided ER diagram
• To update the ER diagram using provided specifications
• To create and update normalized relations of the data from the provided ER
• To create and update Database Schema
• To implement a database based on the provided ER diagram
• To write required SQL statements to query the database

You must use consistent and legible formatting in laying out your SQL queries. Include (brief) comments for any query or procedure that uses an "unusual" approach. The following reports are required:
1. A list of all of the names and phone numbers of all suppliers in alphabetical order by contact name.
2. A list of all corporate customers and their contact details.
3. List all supplier products that begin with an A (either upper case or lower case).
4. A list of all customers (id and name) together with their event(s) including date, time and type of the event.
5. A list of the contact details (names, postal address and phone number) of all of the customers who have requested more than one event.
6. Display each event and all of the details of staff who have worked on the event.
7. Display a list of products that have expired in the last year.
8. Display the item id and the difference between the default price and cost (ITECH5006 - together with a percentage markup) of all products.
9. Display the individual and total product price less cost for an event.
10. Display the staff id(s) for each event together with their cost i.e. what was paid to them in salary,wages and penalties.


Attachment:- ASSIGNMENT.rar

Reference no: EM13312094

Questions Cloud

Determine what is the height of the column of water : If water at 70 degrees C (row=1.94 slugs/ft^3, vapor pressue= 0.363psia) is used in a simple barometer what is the height of the column of water if the atmospheric pressure is 15 psia
Determine the overflow rate and solids loading of clarifier : An activated sludge aeration tank has a width of 14m, a length of 15m and an effective liquid depth of 4.5m. The secondary clarifier has a diameter of 25m. The plant operating parameters are as follows
Stitching together a business with partners : Stitching together a business with partners
Determine the velocity of the steam at the nozzle outlet : Helium enters an adiabatic steady-state nozzle at 200kPa and 124 degrees Celsius and 10m/s. At the nozzle exit the temperature of the helium is 100 degrees Celsius and the pressure = 150 kPa.
To analyse and comprehend a provided er diagram : Display the item id and the difference between the default price and cost (ITECH5006 - together with a percentage markup) of all products.
Determine what is the largest capacity in passenger per hour : All jets including 868 have a runway occupancy time of 60 seconds. The 868 can carry an average payload of 360 passengers while all other jets have an average payload of 200 passengers.
Develop equation that determines mass of finishing rods : When in use, a fishing rod can be approximated to act as a cantilevered beam. Assume that the force (P) is applied to the end of the beam by a fish while the fisherman rigidly holds the other end of the beam.
Literature review gyms and fitness club at sydney : Literature Review: Gyms and Fitness club at Sydney
Determine the elastic modulus of the composite material : An SAE steel wire (1mm diameter) is coated with another cover to form a composite material with diameter of 2 mm. a) determine the elastic modulus of the composite material;

Reviews

Write a Review

Database Management System Questions & Answers

  Types of relationships in a design model of a database

There are many kinds of relationships in a design model of a database. Why is it important to classify each of these types in an ERD Model?

  Draw an er diagram for database scenario

Draw an ER diagram for database scenario. Design a set of 3NF tables for your database scenario.

  What is the role of a dbms

What is the role of a DBMS, and what are it advantages? What are its disadvantages?

  Create state transition diagram to describes student states

Create a state transition diagram that describes typical student states and how they change based on specific actions and events.

  Explain what is the purpose of database

Explain what is the purpose of Database? The purpose of a database is to store information about certain types of objects. Give an example of two related TABLES.

  Write a memorandum to sam jones

Write a memorandum to Sam Jones (CIO) and present your research findings. Your memorandum should be no longer than 500 words.

  Convert table to equivalent collection of tables

determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables.

  Define set of relational schemas and identify primary keys

We want to construct a database for a world-wide package delivery company. Define a set of relational schemas and identify primary and foreign keys. Try not to include redundant schemas.

  Create erd models

Select one of the Real World Scenarios and use the experience you have that is related to the scenario you have chosen or research online; and then post your comments and solutions about your experience.

  Explain the datawarehouse and data mining concepts

There are six major types of information systems which organisations use in their operations. Discuss how these information systems support managers in their decision making role Explain the datawarehouse and data mining concepts using appropria..

  Define a data flow in bus information system

Name four attributes that you can use to define a data flow in the bus information system. Name four attributes that you can use to define a data store in the bus information system.

  Find the entities from the functional requirements

Find the entities from the functional requirements. Entities can come from Nouns in the text, they may also come from forms, reports and legacy code.

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