Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Kristi Castro
Page 8 of 8
Object-oriented Data Model
Object oriented data model is based upon real world situations. These situations are represented as objects, with different attributes. All these object have multiple relationships between them.Elements of Object oriented data modelObjectsThe real world entities and situations are represented as objects in the Object oriented database model.Attributes and MethodEvery object has certain characteristics. These are represented using Attributes. The behaviour of the objects is represented using Methods.ClassSimilar attributes and methods are grouped together using a class. An object can be called as an instance of the class.InheritanceA new class can be derived from the original class. The derived class contains ...
Read MoreThe benefits of good Database Design
A good database design has many benefits and is a goal to achieve for every DBA −Easy Retrieval of InformationIf the design is developed properly, then it would be easier to retrieve information. Correct design means the tables, constraints, and relationships created are flawless.Easier ModificationChanges that you make to the value of a given field will not adversely affect the values of other fields within the table.Easy to MaintainThe database structure should be easy to maintain. The design is perfect if changes in one field is not affecting changes in another field.InformationWith a good design, you can enhance the quality ...
Read MoreMany-to-Many Relationship in DBMS
Many-to-Many relationship in DBMS is a relationship between more than one instance of an entity with more than one instance of another entity i.e. both the entities can have many relationships between each other.The relation can be stated as −Let us see an example −Many Authors can write a Book, whereas an Author has written more than one book.Here, Book and Author are entities.Let’s say a book has two authors, whereas an individual author has written six books till now.
Read More