Now, write the create table statement:
create table friends_etc (pname nm not null, sname nm not null, address varchar(30) null, city varchar(30) not null, state char(2) not null, postalcode char(5) null, phone p# null, age tinyint null, bday datetime not null, gender bit not null, debt money not null, notes varchar(255) null)
You have now defined columns for the personal name and surname, address, city, state, postal code, telephone number, age, birthday, gender, debt information, and notes. Later, you will create the rules, defaults, indexes, triggers, and views for this table.
