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

Ask an Expert

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

Write your message here..

Related Questions

Mysql, he SQL query that will return the order number, quantity ordered, pr... 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

What are the different types of interfaces provided by dbms, Question 1 Su... 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 Authorisation is the culmination of the ad... 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, Differentiate between... 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, Although how will the system recover ... 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

Mr.dattu, Define a job scheduling strategy that will meet business requirem... 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, List two restri... 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

Dbms built for online transaction processing, Problem: A DBMS built for... 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, Explain the function of input contr... 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

What is a sub-query, (a) What is a Sub-Query? (b) What is the differen... (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