When you create a table in a database, you need to identify a suitable name. In this case, you can call it "customers". 2. Based on 'CM Mobiles' requirements the customers table will have three columns: ● username ● full name ● email address3. The customer username contains alphanumeric values such as: Custom001, Custom002, and Custom003. Notice here that the username is always nine characters in length, so choose the CHAR datatype as it allows for a fixed length of characters. In this case, choose 9 characters, no more or less. Therefore you can declare the username in the SQL statement using the following SQL syntax:

Mr. Carl Merkel owns a small business that sells mobile devices called “CM Mobiles”. He wants to create a new table to store key information about customers including customer username, customer full name and customer email address as shown in the following table of data.

You are designing a data model for an e-commerce company. You want to capture customer information like name, email, address, and phone number. Which type of table should you use to store this information?

Mr. Carl Merkel wants to create another basic table in the cm_devices database to store the customers' feedback. This table must include three columns:● Feedback ID column, ● Feedback type column with a maximum of 100 characters, ● A comment column with a maximum of 500 characters.

A college database contains a table called “Students” that has three columns: username, full name and email address. The username column contains alphanumeric values such as “St001” and has a fixed length of five characters. Select the correct SQL syntax for the username column.1 pointusername CHAR(5)username VARCHAR(5)

Create following table using SQL statements.Client tableField name      Data type                AttributesClientno            char(6)                    Primary keyName                 Varchar(20)         Not NullCity                      Varchar(50)          Not NullPin NumberMobile                   Char(10)