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

  Create an xml file with markup tags

Create an XML file with markup tags and some sample data to represent a list of invoices. Include the XML tags for two invoices in the list. Also, assume the invoices are created from a database whose tables are shown in the following database rela..

  Database management systems

An automotive service center or dealer wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how could it help improve their services?

  Explain about where you looking a secure academic database

Explain about where you are looking--a secure academic database? the open Internet? other locations?

  Develop a model to store questionnaires

Develop a model to store questionnaires and its underlying questions. A questionnaire records questionnaire name, primary contact name, start date and expected end date.

  Create the database using three tables

Create the database using three tables: one for student information, one for advisor information, and one for department information.

  Web forms and database interaction assignment description

Web Forms and Database Interaction Assignment description, public static bool SavePersonnel(string Database, string FirstName, string LastName, string PayRate, string StartDate, string EndDate)

  Data warehouses and employee privacy

What should a company consider installing on the network perimeter to prevent direct connections between the internal network and the Internet to help protect its data warehouses and employee privacy

  Basic component of a database system

Which of the following is not a basic component of a database system? Which of the following terms is synonymous with "tuple"

  Benefits of implementing the acme next gen strategy

Describe the benefits of implementing the ACME ‘Next Gen' strategy. Explain why it is important for an airline to use a real- time data warehouse

  What can you tell me about hybrid databases

What can you tell me about hybrid databases? What are the positives and negatives? Are they better than using a OO or Relational database specifically? (Research will be necessary and do not rely solely on Wikipedia)

  Design and implement a small database application

Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database and develop queries in the target DBMS

  Display the final contents of each object''s field.

Write a program the instantiates a RealEstateSalesperson and a Girlscout object.

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