Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions