Subject Specification

1           Course Basics

Course :                       Bachelor of Business in Information Technology (NQF Level 7)

Subject Name  :           Database Management Systems

Subject Code:              IS 213

Duration:                    13 teaching weeks

Contact Hours :           6 x hours per week (Lecture = 2. Tutorial = 2 and Laboratory = 2)

Credit Points:              15

Delivery Mode :           On campus

Prerequisites:              MA114, MA124

Co-requisites:             IS 112

Lecturer:                     Prof. Dr Zhaohao Sun

* Subject Specification = Course Description, which is used in many universities in Australia at least in UoW and FedUni where I used to work.

2           Synopsis

The objective of this course is to teach students how to deal with data, database, and database management systems and practice using database management software such as Microsoft ACCESS and mySQL. The emphasis of the lectures is on practical aspects of data modeling at the conceptual level such as creating entity relationship diagrams and normalization and finally implement the data models using database management systems such as Access or mySQL. Main topics covered include: components of DBMS, data design using ERD, conversion of ERD to relational schema, normalization, query, and SQL.

Today’s business world could not function without data communications and computer networks. Most people cannot make it through an average day without encountering or using some form of computer network. In the past, this field of study occupied the time of only engineers and technicians, but it now involves business managers, end users, programmers, and just about anyone who might use a phone or computer! Thus, Data Communications & Computer Networks, maintains a business user’s perspective on this vast and increasingly significant subject.

In a world in which computer networks are involved in nearly every facet of business and personal life, it is paramount that each person understands the basic features, operations, and limitations of different types of computer networks. This understanding helps people become better managers, better employees, and simply better computer users. As a computer network user, you will probably not be the one who designs, installs, and maintains the network. Instead, you will have interactions—either direct or indirect—with the individuals who do. Taking this course should give you a strong foundation in computer network concepts, which will enable you to work effectively with network administrators, network installers, and network designers