Question

Write the procedure of creating a new table in a database

Answer 1

CREATE TABLE table_name
(

[id] [char](2) NOT NULL AUTO_INCREMENT,

[name] [varchar](30),

CONSTRAINT [PK_id]
)
etc

Answer 2

Answer:

1. Start database.

2. Click the "Blank desktop database"

template.

3. Type a file name for the database.

4. Choose the folder where to store

database.

5. Click on the Create button.

6. Save the database.

7. Use different features on it and

apply it on database.

8. Create or open database.

9. Create table.

10. Suitable name for table.

11. Add fields on table.

12. Name of field should be as per

proper convention.

13. Choose appropriate data types for

representation of type of data.

14. Check the validity of data in each

field. Such as primary key

assignment.

15. Save the table.

16. Close the table.

17. Close the database.

Explanation:These are theoretical procedures.