DBS201 - Introduction To Database and SQL

Subject Title
Introduction To Database and SQL

Subject Description
This subject introduces students to relational database design and SQL (Structured Query Language) used with relational databases. Students will be introduced to a history of database management covering hierarchical, network, relational and object oriented models with a focus on the relational model and its operators. Students will be presented with a methodology for relational database design using Entity Relationship Diagrams and normalization of data. Students will be introduced to a subset of SQL using IBM's DB2 on the iSeries platform. An overview of the functions of the Database Management System (DBMS) and of a Database Administrator (DBA) will also be presented.

Credit Status
1 Credit for CPD/CPA Diploma Students

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Use SQL to create and modify tables in DB2 databases

2. Work in groups on a project to design and create a DB2 database for an application requiring a minimum of 8-12 table.

3. Merge normalized relations from each user view into a complete set of normalized relations for a simple business application

4. Prepare an Entity Relationship Diagram for a simple business application

5. Use SQL to retrieve data from DB2 databases

6. Prepare the physical relational database schema for a simple business application

7. Identify user views for an application

8. Normalize a user view to 3rd Normal Form

9. Describe the basic differences between relational, hierarchical and network databases

10. Describe the basic functions of a Database Management System

11. Describe the responsibilities of a Database Administrator in an organization

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

Discrimination/Harassment
All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.