Steps for creating a table in DBMS
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
Expert
The main steps to create a table in DBMS are as follows:
1. Recognize the data type, precision, and length for each and every attribute.
2. Recognize the columns which can accept a null value.
3. Recognize the columns which need to be exclusive.
4. Recognize related and primary foreign keys with the parent table being created ere the child.
5. Examine default values.
6. Examine where the domain values are which require to be constrained.
7. Create or make the indexes.
Elucidate what are the tasks which Load manger process will do?
Name some of the applications that use Multilinked Structures?
State functionality of the repository manager?
Explain the repository domains?
Describe briefly Aggregate transformation?
Explain the Rank, Router, Sorter transformation?
Explain for what the Supervisor module is used?
Specify the other areas for the purpose of Data warehousing and the data mining.
Explain about a Cartesian product?
What do you mean by optimization and performance tuning and explain how does it actually work in the practical projects?
18,76,764
1928629 Asked
3,689
Active Tutors
1415064
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!