This topic contains a solution. Click here to go to the answer

Author Question: To create a new SQL query, click the New Query button. Indicate whether the statement is true or ... (Read 211 times)

tnt_battle

  • Hero Member
  • *****
  • Posts: 556
To create a new SQL query, click the New Query button.
 
  Indicate whether the statement is true or false

Question 2

Describe and discuss the main elements of the Entity-Relationship (E-R) model. Include an example.
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ASDFGJLO

  • Sr. Member
  • ****
  • Posts: 335
Answer to Question 1

FALSE

Answer to Question 2

The E-R model is basically made up of entities, attributes and relationships. Entities represent the things people want to keep track of, such as customers and products. Each thing is presented by an entity or entity classin this case CUSTOMER and PRODUCT. Individual members of each entity class are called entity instancesfor example CUSTOMER John Smith and PRODUCT Canned Tomato Soup. Each entity is described by a set of attributes. For example, a CUSTOMER will have a CustomerNumber, a LastName and a FirstName, while a PRODUCT will have a ProductNumber and a Description. These, of course, have specific values for each entity instance. Finally, the entities are connected by relationships. There are relationship classes between entity classes and relationship instances between entity instances. For example, in general a CUSTOMER buys a PRODUCT, and a PRODUCT is sold to a CUSTOMER. Specifically, CUSTOMER John Smith buys a PRODUCT Canned Tomato Soup.




tnt_battle

  • Member
  • Posts: 556
Reply 2 on: Jul 7, 2018
:D TYSM


cpetit11

  • Member
  • Posts: 321
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

Did you know?

The largest baby ever born weighed more than 23 pounds but died just 11 hours after his birth in 1879. The largest surviving baby was born in October 2009 in Sumatra, Indonesia, and weighed an astounding 19.2 pounds at birth.

For a complete list of videos, visit our video library