User Account

All Pages

Determine the data types and additional column properties

Assignment Help Database Management System
Reference no: EM131076688

Assignment- E-R model work

We have developed the E-R model for the Highline University database. See below for a copy of the final data model (created in MS Visio) we developed in class. After you have reviewed the E-R model, create a relational database design for the model.

1. For each entity in the E-R model, specify a table structure, determine the data types and additional column properties, identify primary keys and foreign keys, and verify normalization on the resulting tables. Refer to the metadata table of Figure 5-26 on page 312, Chapter 5 in the textbook as a guide for format to document detailed column properties.

2. Document referential integrity constraint enforcement actions and any business rules that you think are important. Use the provided RI table template below to fill in as appropriate (similar to part of your team project D3 requirements). You can also refer to Figure 5-29 on page 317, Chapter 5 in the textbook for an example.

Relationship

Referential Integrity Constraint

Cascading Behavior

PARENT

CHILD

ON UPDATE

ON DELETE






























Reference no: EM131076688

Questions Cloud

Disadvantages of open questions in course evaluations : What are the advantages and disadvantages of Open questions in Course Evaluations?
How do scholars use the term myth : List the names of the five countries with the largest populations (in population order). What are the primary differences between the statistics of religious believers worldwide and the statistics of religious believers in the United States?
What are the factors that cause shifts in supply : The factors that cause shifts in supply and the importance of demand are examined. What is the law of supply, and what are the factors that cause shifts in supply? What is the law of demand and why is it important? Why does an increase in the price o..
Binding minimum wages cause frictional unemployment : Complete the following table with the quantity of labor supplied and demanded if the wage is set at $9.00. Then indicate whether this wage will results in a shortage or a surplus. Hint: Be sure to pay attention to the units used on the graph and in t..
Determine the data types and additional column properties : For each entity in the E-R model, specify a table structure, determine the data types and additional column properties, identify primary keys and foreign keys, and verify normalization on the resulting tables.
Transaction deposits and existing non transaction deposits : According to statistics provided by the Federal Reserve, total reserves of commercial banks currently equal $1.63 trillion. Required reserves are $130 billion, so excess reserves total approximately $1.50 trillion. Would the existing reserves be suff..
Reserve requirements associated with existing deposits : It has been determined that, in aggregate, financial institutions with depository accounts currently hold excess reserves equal to $3 billion—that is, they hold $3 billion more than is necessary to meet the reserve requirements associated with existi..
Would you advocate restricting the freedom of the press : Under what circumstances, if any, would you advocate restricting the freedom of the press, and to what degree would you restrict it? Substantiate your answer with logical arguments and/or evidence.
Calculate the accounting profit for pottery firm : Gomez runs a small pottery firm. He hires one helper at $14,500 per year, pays annual rent of $7,500 for his shop, and spends $18,000 per year on materials. Calculate the accounting profit for Gomez’s pottery firm?

Reviews

Write a Review

Database Management System Questions & Answers

  Problem 1suppose you have a relation schema about teaching

problem 1suppose you have a relation schema about teaching classes that has the following attributes class instructor

  Create an update query to select all records in the tbl over

Create an update query to select all records in the tblOverPriced, decrease the Price field values by 10%, run and close the query.

  Draw an entity-relationship diagram for the database

Carefully read the above business description and draw an Entity-Relationship Diagram (ERD) for the database that manages information on employees, customers, and so on

  What is the advantage of storing data in database

When would you store data in database and when would you use functions

  Provide the sql to amend the original table design

You have been given the following specifications of a simple database for a netball association that keeps record of players, teams and matches.

  Big data

The technical briefs will have you summarize in your own words some key topics related to databases and big data. Assume that you have been asked by the CEO in the organization that you work for to give him or her a paper on a topic he heard about wh..

  Calculate total cost of booking

What the club needs is something that will allow the booking officer to record all details of a booking accurately and quickly. They should be able to print this out as an invoice, which can post or email prior to the booking - switchboard with we..

  Database management system create a database design

database management system create a database design specification enhanced entity relationship diagram eerd and

  List and summarize all new loans for residential housing

This analysis report will clearly list and summarize all new loans for residential housing in the past month

  Appropriate output decision from system analyst perspective

A summary report of the company's financial situation is needed by a key decision maker, who will use it when presenting a proposal to potential external backers.

  Display the results in descending order by the gross sales

Display all the columns from the Orders table that were paid with a Visa Card and have been shipped to the customer (hint: not a null). Order results by the Item Price in descending order.

  Assignment on sql code

SQL 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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd