Scribd
Upload
55 views2 pages

Activity in Database System

The document provides instructions for students to perform SQL operations to create a database called flower_orders and 3 tables - customer_info, order_info, and flower_info. Students are tasked to insert, update, and delete records in the tables and perform select statements on the data. Their work will be scored based on completing the tasks correctly.

Uploaded by

ririyoru
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
55 views2 pages

Activity in Database System

The document provides instructions for students to perform SQL operations to create a database called flower_orders and 3 tables - customer_info, order_info, and flower_info. Students are tasked to insert, update, and delete records in the tables and perform select statements on the data. Their work will be scored based on completing the tasks correctly.

Uploaded by

ririyoru
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Republic of the Philippines

Bohol Island State University


Calape, Bohol
DEPARTMENT OF COMPUTER SCIENCE
DATABASE SYSTEMS (INFORMATION MANAGEMENT) (MySQL)
2nd Semester 2023-2024
Activity : February 5, 2024
I. General Instruction. Perform the following SQL operations below.
1. Create a database and name it with: flower_orders.
2. Create database tables as shown in the ERD below. customer_info, order_info and
flower_info.

customer_info order_info
cus_id order_id
cus_firstname cus_id
cus_lastname flower_id
cus_middlename order_date
cus_contactNumber order_quantity
cus_gender order_amount
cus_status order_status

flower_info
flower_id
flower_description
flower_design_name
flower_category
flower_status
flower_price

3. In creating the database tables, provide each field with the proper constraints.
4. Once the 3 database tables are done, perform 5 insert for customer_info and 5 insert
flower_info tables.
5. Once the customer_info table and flower_info tables contains information, proceed
now in inserting information to order_info table, insert 3 row of information. Make sure
that the data from the 3 tables are related.
6. Perform 2 updates in customer_info, order_info and flower_info tables.
7. Perform 2 deletes in customer_info, order_info and flower_info tables.
8. Perform 10 different kinds of SELECT out of the 3 database tables.
9. In every result of your SQL Statements, make sure to screenshot and paste in the
Microsoft Word for checking.
Scoring:
Indicator Points Score
1. Create Database 3
2. Create 3 Database Tables 15
3. 5 insert in customer_info table 5
4. 3 insert in order_info table 5
5. 5 insert in flower_info table 5
6. 2 updates in customer_info table 2
7. 2 updates in order_info table 2
8. 2 updates in flower_info table 2
9. 2 delete in customer_info table 2
10. 2 delete in order_info table 2
11. 2 delete in flower_info table 2
12. 10 different select statements 10
TOTAL: 54
Prepared by:

GARDSON BINASBAS
Subject Instructor

You might also like