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


mammy1697

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

 

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

For a complete list of videos, visit our video library