Determine advantages of merging an association into a class, Database Management System

Assignment Help:

What are the advantages and disadvantages of merging an association into a class?

Advantages:

i) Less number of tables

ii) Faster performance due to the fewer tables to navigate.

Disadvantages:

i) Less design obstinacy

ii) Reduced Extensibility

iii) Increased difficulty

Related Discussions:- Determine advantages of merging an association into a class

How many types of views are there, How many types of Views are there? ...

How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View

What are the advantages of object id, What are the advantages of object ID?...

What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing ii) IDs are completely independent of the changes in data v

Components of a typical database environment, Question: (a) List four d...

Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

What is system log, What is system log? What are the entries? An...

What is system log? What are the entries? Ans: The system log that is generally written on stable storage contains the redundant data required to recover from volatile

Create a database, The database will enable college administrators the abil...

The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals an

Index and tree structure, Index And Tree Structure Let us talk about th...

Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider

Normalization, Introduction In large projects, we can have many different ...

Introduction In large projects, we can have many different companies working together. Generally, the project or contract is awarded to one company (Principal Contractor), which

What are deadlocks, What are deadlocks? How can they be avoided? Ans:...

What are deadlocks? How can they be avoided? Ans: Deadlock considers to a particular condition when two or more processes are every waiting for another to release a resource,

Relational algebra, what is union compatable?

what is union compatable?

Which component of dbms can be embedded in a program, which component of DB...

which component of DBMS can be embedded in a program? The data manipulation language (DML) is a component which is embedded in a program.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages