Database Management Lab GTEC 2103

Course description:

This lab enables the students to practice the concepts learnt in the subject Database Management by developing a database. The student is expected to practice the designing, developing and querying a database. Students will apply structural query language SQL to CREATE TABLE IF NOT EXISTSs and apply the relations between them. In addition, Students are expected to use SQL Server or My SQL to develop an example project.

Course Aims:

This course aims to enable the student to:
  • Create a simple database.
  • Apply SQL using SQL Server or MySQL program.  
  • Develop a complete database system.

Course outcomes:

Upon completion of the course, student should be able to:
  • Design and implement a database schema for given problem. 
  • Apply the normalization techniques for development of application software to realistic problems.
  • Formulate queries using SQL commands.