« previous next »

Author Question: Using the VRG database as an example, briefly describe what a final database design consists of. ... (Read 30 times)

shofmannx20

  • Hero Member
  • *****
  • Posts: 562
on: Jul 7, 2018
Using the VRG database as an example, briefly describe what a final database design consists of.
 
  What will be an ideal response?

Question 2

MySQL supports BEFORE triggers.
 
  Indicate whether the statement is true or false


1_Step_At_ATime

  • Sr. Member
  • ****
  • Posts: 342
Reply #1 on: Jul 7, 2018
Answer to Question 1

The obvious part of the database design is the ER drawing itself, for example as shown for VRG in Figure 6-39. However, this needs to be accompanied by a summary of the database design relationships as shown in Figure 6-40. This document summarizes the cardinalities of relationships. For each relationship, we need a set of actions to enforce the minimum cardinalities. These can be based on Figures 6-28(a) and 6-28(b), the examples for VRG are shown in Figures 6-41 and 6-42. Finally, we need a set of column characteristics for each table, as shown in Figure 6-43 for VRG.

Answer to Question 2

TRUE


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Atherosclerosis. (a) A sectioned coronary artery that exhibits an accumulation of fatty plaque, whic Atherosclerosis. (a) A sectioned coronary artery that exhibits an accumulation of fatty plaque, whic
A Subtitle C Landfill Design A Subtitle C Landfill Design
Masamichi Udagawa and Sigi Moeslinger, Antenna Design, Knoll Toboggan Chair. Masamichi Udagawa and Sigi Moeslinger, Antenna Design, Knoll Toboggan Chair.
Find the final amount if the initial amount is 400 units. Find the final amount if the initial amount is 400 units.
Shell-Tube CHE 413 Chemical Engineering Equipment Design Shell-Tube CHE 413 Chemical Engineering Equipment Design
Rational design of neuraminidase inhibitors Rational design of neuraminidase inhibitors
Video: Hyperglycemia Animation

For a complete list of videos, visit our video library