Question: Table Name: person Field person_id Notes int(8) Primary key Auto-increment value Required Required Reguired first name last name varchar(25) varchar(25) Table Name: contact list Field

 Table Name: person Field person_id Notes int(8) Primary key Auto-increment valueRequired Required Reguired first name last name varchar(25) varchar(25) Table Name: contactlist Field connection id Notes int(8) Primary key Auto-increment value Reguired RequiredReguired person id contact id int(8) int(8) Table Name: message Field message_id

Table Name: person Field person_id Notes int(8) Primary key Auto-increment value Required Required Reguired first name last name varchar(25) varchar(25) Table Name: contact list Field connection id Notes int(8) Primary key Auto-increment value Reguired Required Reguired person id contact id int(8) int(8) Table Name: message Field message_id Notes int(8) . Primary key Auto-increment value Reguired Required Reguired int(8) senderid receiver id message send datetime int(8) varchar(255) datetime . Required Required Task 1: Insert Record to the Person Table Construct the SQL statement to add yourself to the Person table. Note: You are required to add yourself as a new record in the "person" table. Use your first name and last name for one of the new records that you are inserting Task 2: Alter the Person Table Construct the SQL statement to alter the table named "person". The columns, column data types, and column notes are provided in the previous section. You need to alter the table to include an additional column of your choice. This column should represent some property of a person. You can choose the data type for the column and any constraints on the column

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!