1. Creates relations between the data throughout the database. Makes it easier to search and query data from the database.
2. Entities – Customer, Departments, and Garments.
Attributes – CustID, CustName, CustDetail, DeptID, DepDetail, GarmentDetail, and GarmentID.
Relationships – Transacts and Selects.
3. Helps to streamline the database. Creates a structure for the database that acts as a developmental prototype.
4. Object oriented databases reuse the objects in the database. Allows you to specify the structure of complex of objects.
Relational databases organize and store all the data and relationships between the data in tables.
5. It gives a real world perspective towards the database.
6. Independent – Exists independently and have properties specific to them.
Dependent – Entities that depend on other entities.
7. NULL is used when a attribute value for a particular entity is not applicable.
8. Total – All the entities of a specific type participate in at least one relationship.
Partial – Only some of the entities of an entity set participatein the relationship instance.
9. Primary Key – uniquely identifies an entity.
Candidate Key – A combination of attributes that are used to uniquely identify an entity.
10. The methods defined in an object hide the member variables of the object from other objects in the program.
11. If you have an entity named coats, with the subgroups of leather, down, and thermal, the subgroups will “inherit” or copy all of the same attributes of the entity coat.
12. The object type classifies the “object into a category.
