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.
Describe briefly reusable transformations?
Illustrates storing of data in stored procedures increase the access time?
What types of tables derived from the ERD?
Write a brief note on the differences between a data warehouse and data mart?
Write about the components of the Ascential Data Stage?
Explain the term Data mart?
Define the way of passing of variables to a SQL routine.
Illustrates a stored procedure?
Illustrates the term Open Server in Sybase?
Explain different domain which is there in BO?
18,76,764
1930212 Asked
3,689
Active Tutors
1444507
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!