Write names and e-mail addresses showing foreign key columns

Assignment Help Database Management System
Reference no: EM1386021

Suppose the database has the following tables;

CUSTOMER (CustomerSK, Name, Phone, EmailAddress)
STOVE (SerialNumber, Type, Version, DateofManufacture)
REGISTRATION (CustomerSK, SerialNumber, Date)
STOVE_REPAIR (RepairInvoiceNumber, SerialNumber, Date, Description, Cost, CustomerSK)

Write down the SQL code to complete the following requests.

1. Illustrate all the data in each of four tables. Don't show foreign key columns.
2. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.
3. Write all \versions of stoves which are of a type "Maytag" and they have not spent any money on repairs.

Reference no: EM1386021

Questions Cloud

Analogue of max flow min cut theorem-capacitated network : Explain how to define the s-t cut on node capacitated network as opposed to edge capacitated network, and how would one illustrate that analogue of the max flow min cut theorem.
Compute the recipe to make desired solution : You require to prepare 200 uL of each protein at a concentration of 1mg/mL for an upcoming experiment. Compute the recipe to make each desired solution at the above concentration and volume.
Problem related to national exercise rate : A researcher believes that the percentage of people who exercise in California is greater than the national exercise rate. The national rate is 20%. The researcher gathers a random sample of 120 individuals who live in the California and finds tha..
Efficiency of biological oxidation of glucose by respiration : G for complete oxidation of glucose is -686 Kcal/Mole. According the G for ATP and number of ATP's produced from the complete oxidation of glucose calculate the efficiency of biological oxidation of glucose by respiration.
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.
Which approaches to employee development are used : Which approaches to employee development are used at Patagonia? How does employee development at Patagonia contribute to the company's strategies relating to employee retention
Regression equation to explain outcomes : At times we can generate a regression equation to explain outcomes. For example, an employee's salary can often be explained by their pay grade, appraisal rating, education level, etc.
Theorist and sources of the theories : Determine two key theories in your field. Determine the theorist(s) and sources of the theories (key articles or books) in your discipline. Explain the basic tenets of these theories.
Describing the change management approach : Describing the change management approach and recommended action steps you would advise for minimizing adverse impact on the organization and its people.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explain what information is available in relational database

Explain what information is available from relational database containing one relation with attributes Name, Employee identification number, and Address which is not available.

  Design a set of 3nf tables for database scenario

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

  Explain the problems associated with data redundancy

Assignment 5: Logical Design, Part II, Explain the problems associated with data redundancy as it pertains to effectively using information for reporting and analysis.

  Find out which data from database to archive

Find out which data from database to archive; that is, for each table, Write down whether data requires to be archived.

  Determine cost of least expensive part in part table

Write a query to determine the cost of the least expensive part in the part table? Format the returned price in dollars and cents using the correct function.

  Use sql to create database

Use SQL to create the following database; to including referential integrity. You may NOT use the GUI for this part of the exercise. COURSE ( CourseNu, CourseName, CreditHrs).

  Write command to list all employees in descending order

Write a command to list all the employees hired in 2003 and 2004. Sort the rows by the hire_date column in descending order.

  Sketch diagram for data warehouse of shop by star schema

Assume that data warehouse for video game shop consists of th three dimensions: time, player, and game, and two measures number of games played and price paid per game. Sketch schema diagram for data warehouse using the star schema.

  Explaining database security relate to data integrity

In talking about database security, some aspects to regard as are Data Integrity, Confidentiality, and Malicious Activity. Illustrate how does database security relate to data integrity?

  Specify the foreign keys for schema

First, specify the foreign keys for this schema, stating any assumptions you make. Next, populate the relations with a few example tuples.

  Differentiate between the interaction types and styles

Explain the conceptual model employed in the design of these types. Describe the analogies and concepts these monitors expose to users, including the task-domain objects users manipulate on the screen.

  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.

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