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 224 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
Excellent


Joy Chen

  • Member
  • Posts: 354
Reply 3 on: Yesterday
Gracias!

 

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

The senior population grows every year. Seniors older than 65 years of age now comprise more than 13% of the total population. However, women outlive men. In the 85-and-over age group, there are only 45 men to every 100 women.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

For a complete list of videos, visit our video library