Write the script to build the database in t-sql

Assignment Help Database Management System

Reference no: EM131660902

Assignment: Database Management

Case

For Assignment, you designed a Relational Data Model for Emerging Electric. For this assignment, you are requested to design the Physical Data Model and build the database.

The input for the Physical Data Model are the Relational diagram you built for Assignment, the points from the Analysis phase below, and the additional requirements below.

Analysis Phase Requirements

After some initial analysis, it has been established that at a minimum the following entities and attributes are needed:

• Customer, with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone
• Location, with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential)
• Rate, with attributes Rate Class and RatePerKWH

After interviews with the owners, you have come up with the following business rules:

• Customers can have one or more Locations.
• Each Location can have one or more rates, depending on the time of day.
• Customers are required to have service at least at one Location.
• Each Location is required to have at least one rate.

Additional Requirements

1. The Database will be named with your first name plus last name initial. Example. Aldo

Gonzalez → ALDOG

2. Appropriate data type for each column must be chosen. RatePerKWH is a number.

3. You must run the script and verify that it works before submitting it.

4. Write the script to build the database in T-SQL. That is the SQL version we are using in all the Lab scripts

5. The script must include create all tables, add all columns, create primary keys and foreign keys as needed.

Deliverables

1. A .sql file with the script to build the database in T-SQL.

Report Presentation

1. Report must be in a Microsoft Word document with the deliverables listed above.

2. Important: start working on it immediately after class that follows the Midterm exam; you may not finish, but questions will pop up that you can then get answered in class.

Attachment:- Millennium-College-3-NF.rar

Reference no: EM131660902

Questions Cloud

Determine the activation barrier : Determine the activation barrier for this reaction. What is the rate constant at 425 K?

What is the maximum profit he can make : Wheat requires 2 gallons of pesticide for every acre planted and barley requires just 1 gallon per acre. What is the maximum profit he can make?

Identify the element oxidized : In the above redox reaction, use oxidation numbers to identify the element oxidized, the element reduced, the oxidizing agent and the reducing agent.

Does the company have a reasonable performance measurement : Does the company have a reasonable performance measurement

Write the script to build the database in t-sql : You must run the script and verify that it works. Write the script to build the database in T-SQL. That is the SQL version we are using in all the Lab scripts

Formula of the reducing agent : In the above redox reaction, use oxidation numbers to identify the element oxidized, the element reduced, the oxidizing agent and the reducing agent.

Explain cost-benefit analysis : Explain a cost-benefit analysis and how it may be relevant to environmental issues.

Can the insider legitimately share the profit on stock sale : SOCIAL D IMENSIONS. Suppose that a corporate insider, without revealing any material, nonpublic information, advises a friend to buy stock in the company.

Prepare that same solution : How much solute would it take to prepare solution with 122 g of 0.540m in KCL? How much solvent would it take to prepare that same solution?

User Account

All Pages