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 124 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


AISCAMPING

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

 

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

For a complete list of videos, visit our video library