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

Author Question: Describe and give an example of generalization and specialization. What will be an ideal ... (Read 28 times)

Ebrown

  • Hero Member
  • *****
  • Posts: 567
Describe and give an example of generalization and specialization.
 
  What will be an ideal response?

Question 2

What does integrity mean in the context of data management?
 
  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

makaylafy

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

Generalization is a relationship in which one class is the more abstract expression of the properties of a set of classes: a Tree class embodies properties common to Oak, Birch, and Cedar classes. Conversely, specialization is a relationship in which a class is the less abstract expression of another class: a Rose is a Flower but the Flower class does not express the specific features of a Rose that sets it apart from other flowers. The result of generalization is a superclass (or a parent), while specialization arrives as subclasses (or children).

Answer to Question 2

A relational DBMS protects data integrity at four levels: column (or attribute), row (or entity), inter-table, and procedural.
 Attribute integrity is ensured by type definition, foreign keys, and constraints.
 Entity integrity is assured by the primary key: one, and only one, entity within a table can be identified by a specific value (or combination of values) in the primary key.
 Inter-table integrity is called referential integrity and is implemented by enforcing the constraints of foreign keys.
 Procedural integrity is used when the relationships among entities are too complex for the other mechanisms. The main tools of procedural integrity are triggers, stored procedures, and transaction processing.





 

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

About 80% of major fungal systemic infections are due to Candida albicans. Another form, Candida peritonitis, occurs most often in postoperative patients. A rare disease, Candida meningitis, may follow leukemia, kidney transplant, other immunosuppressed factors, or when suffering from Candida septicemia.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

In most climates, 8 to 10 glasses of water per day is recommended for adults. The best indicator for adequate fluid intake is frequent, clear urination.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

For a complete list of videos, visit our video library