Question

Write a MySql command for creating a table "BANK” whose structure is given below:​

Answer 1

The command to create the table as per the question is as follows:

$\tt Create\ table\ Bank(Acct\_Number\ int(4)\ Primary\ Key,\ Na me\ varch ar(3),\\ BirthDate\ date,\ Balance\ int(8)\ Not\ Null);$

$\tt Create\ table$ is a DDL command used to create tables under selected databases. Once you call out this command, you need to specify the column names, along with their data types and sizes, and constraints [if any.]

The Primary Key constraint is used to ensure that all values under this column are unique values and there are no repeated values. It helps eliminate redundancy of data.

The Not Null constraint is used to ensure that there are no empty values in this column.