Example HTML page

MySQL Assignment 2

Hi,

The following questions are based on creating a table.

1. Create a Table with name person. The attributes of the table includes person id, name, gender, age, living_location.

2. Create a Table with name person using IF NOT EXISTS clause.

3. Create a Table with name Student. The attributes of the table includes student register_no, first_name, Last_name, gender, class, section, grade.
class may take  values from – 1 to 10
section may take values from  – A to E
grade may take values from –  A to E

4. Create a Table with name Post. The attributes of the table includes post id, post_name, published_date, author_name, topic_name, description. description is of ‘text’ data type, which includes one or two lines of description about the topic.

5. Create a Table with name users. The attributes of the users table includes user_id, user_name, user_password, user_email.
Here the user_id attribute should not allow NULL values.

6. Create a Table with name Employee. The attributes of the table includes:
first_name
last_name
email
street
city
state
zip
phone
Date_of_Birth (DOB)
Joining_date
gender
designation
experience
Here the employee id should not allow NULL values and it must be unique.

7. Create a Table with name Employee_main from the existing table Employee.
Employee_main contains Emp_id, designation, experience

8. Drop the Table Employee_main.

9. Drop the Table Employee_main using IF EXISTS clause.

10. List out the current tables in your Current Database.

 

Example HTML page

Leave a Reply

Your email address will not be published. Required fields are marked *

Pin It on Pinterest