State the terms designing the database and normalization, Database Management System

State the terms Designing the database and Normalization

Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the tables must contain and the relationship between these tables.

Normalization: This is a process of removing dissimilar kinds of impurities from the tables we have just created in the above step..

 

Posted Date: 7/26/2013 5:47:48 AM | Location : United States







Related Discussions:- State the terms designing the database and normalization, Assignment Help, Ask Question on State the terms designing the database and normalization, Get Answer, Expert's Help, State the terms designing the database and normalization Discussions

Write discussion on State the terms designing the database and normalization
Your posts are moderated
Related Questions
he SQL query that will return the order number, quantity ordered, price each and total cost of an order (quantity * price each) from the order details table. Label the calculated c

Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

Authorisation Authorisation is the culmination of the administrative policies of the organisation.  As the name shows, authorisation is a set of rules that can be used to verif

Differentiate between a unique key and a primary key. - By default, clustered index on column are created by primary key while nonclustered index are created by unique key.

Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is

Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

Problem: A DBMS built for Online Transaction Processing (OLTP) is usually regarded as unsuitable for data warehousing. Each system is designed with a different set of requireme

Explain the function of input controls. Identify four types of input control and explain the function of each. Provide an example of a data integrity error that could occur i

(a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh