Creating a table in the database

Now that we've created a database, we can walk through how to create a table in the database. We need to remember what we learned in Chapter 3, Understanding Data Types, regarding how to correctly apply data types. We also need to remember what we covered in Chapter 1, Introduction to Relational Database Management Systems, about data integrity. This information will form a vital part of our method when we properly create a table.

Understanding how to apply data types and data integrity to your table

Let's briefly review what we covered about data integrity in Chapter 1, Introduction to Relational Database Management Systems.

Database integrity refers to the consistency and accuracy...