Database Design Lab
Database Design Lab
Embedded Files
Lab 1
Lab 1
Students are given an overview of what this lab is about and how it will be conducted.
Lab 2
Lab 2
File: Mini Server
Notes: MySQL Data Types
Videos:
SQL vs MySQL (9 mins)
MySQL Data Types (18 mins)
Creating a Table & Populating it w/ Data (24 mins)
(The video description contains the SQL statements used)
Lab Task
Lab Task
File: Worksheet 1
Complete the first two tasks where you have to create a table and then insert the specified data. You will need to submit your work, so first save the SQL statements in a .txt file. It will also help you to rectify errors easily as demonstrated in one of the videos. Furthermore, all submissions must follow the format given here.
Lab 3
Lab 3
Videos:
Manipulating Data & Table - UPDATE, SET, WHERE, DROP, ALTER, ADD, MODIFY (22 mins)
Retrieval Queries - DISTINCT, ORDER BY, BETWEEN, AS, NOT, AND, OR, YEAR, LIKE (37 mins)
For both the videos, the SQL statements used can be found in the description box.
Lab 4
Lab 4
Notes: More SQL Keywords
Videos:
More SQL Keywords (11 mins)
Aggregation (14 mins)
Sub Queries (18 mins)
Submit project name and group member info. A group can have at most 5 students. No two groups can work on the same project.
Lab 5 - Test 1
Lab 5 - Test 1
Syllabus: Everything covered so far
Queries written via a form field must abide by the instructions given here.
Lab 6
Lab 6
Video: Inserting Data Using a Web Page (28 mins)
Submit the EER diagram of your project.
For reviewing relevant concepts, check the contents of Classes 7, 8 and 10 from here.
Lab 7
Lab 7
Lab Task
Lab Task
File: Worksheet 4
Complete tasks 1 and 2. Watch this video for additional info on how to complete them.
Submit the schema diagram of your project.
For reviewing relevant concepts, check the contents of Classes 14, 15 and 16 from here. Ideally, the schema should be normalized.
Lab 8
Lab 8
Videos:
Joining Three Tables (24 mins)
Joins Involving Subqueries (18 mins)
Lab Task
Lab Task
File: Worksheet 4
Complete task 3. Submissions must be done by editing this file in the same format as the first solved problem.
Submit the SQL features of your project.
Lab 9 - Test 2
Lab 9 - Test 2
Syllabus: Everything covered so far with an emphasis on Worksheet 4
Lab 10 - Project Demo
Lab 10 - Project Demo
Students are required to demonstrate their project.
Final Exam
Final Exam
Syllabus: Everything covered so far
Google Sites
Report abuse