What are the different approaches for database design, Database Management System

Assignment Help:

What are the different approaches for database design?

There are two basic approaches for database design which are as follows:

Attribute driven: It compiles a list of attributes relevant to application, and normalizes the groups of attributes which preserve functional dependencies. Entity driven: It discovers entities which are meaningful to application, and describe them.

Related Discussions:- What are the different approaches for database design

What are the ways in which signal can be generated, What are the ways in wh...

What are the ways in which signal can be generated A signal might be generated in many ways such as a Signal is result of particular physical condition. Whenever a process writ

Explain stand alone query language in details, Explain Stand Alone Query La...

Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no

Explain the recoverable schedule, Explain the Recoverable Schedule A r...

Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm

Hierarchical data model, what is definition hierarchical data model

what is definition hierarchical data model

How many block accesses average saved on using secondryindex, Normal 0 ...

Normal 0 false false false EN-US X-NONE X-NONE

Create a view containing name and number of department, Create a view emp_d...

Create a view emp_dep containing e_name and number of dependents from the tables employee and dependent of (i) CREATE VIEW emp_dept AS SELECT ename, COUNT(*) FROM employee, dep

Explain cascade and restrict clauses of drop schema command, Explain severa...

Explain several types of constraints that can be specified using CREATE TABLE command. Explain CASCADE and RESTRICT clauses of DROP SCHEMA command? Constraint Description PRIM

What are the two statements regarding transaction, What are the two stateme...

What are the two statements regarding transaction? The two statements regarding transaction of the form are:- A) Begin transaction B) End transaction

Explain b-tree, What is B-Tree? A B-tree eliminates the redundant stora...

What is B-Tree? A B-tree eliminates the redundant storage of search-key values .It permits search key values to appear only once.

Describe relational model, Describe relational model? Structure of rela...

Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages