Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Mysql any help is appreciated!! 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)
Mysql any help is appreciated!!
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 columnStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started