COURSE SYLLABUS

DATABASE MANAGEMENT SYSTEMS

1	Course Title:	DATABASE MANAGEMENT SYSTEMS
2	Course Code:	END3238
3	Type of Course:	Optional
4	Level of Course:	First Cycle
5	Year of Study:	3
6	Semester:	5
7	ECTS Credits Allocated:	3
8	Theoretical (hour/week):	1
9	Practice (hour/week) :	0
10	Laboratory (hour/week) :	2
11	Prerequisites:	-
12	Recommended optional programme components:	None
13	Language:	English
14	Mode of Delivery:	Face to face
15	Course Coordinator:	Dr. Ögr. Üyesi BESİM TÜRKER ÖZALP
16	Course Lecturers:	-
17	Contactinformation of the Course Coordinator:	tozalp@uludag.edu.tr, 0-224-2942090, Endüstri Müh. Bölümü Oda No:302 Görükle Bursa
18	Website:	http://www20.uludag.edu.tr/~tozalp
19	Objective of the Course:	The objective of this course is to learn how to design, manipulate and encourage the usage of database management systems for effective data management.
20	Contribution of the Course to Professional Development

Learning Outcomes:

1	Define a Database Management System.;
2	Define basic foundational terms of Database.;
3	Analyze organizational information requirements using the entity-relationship approach and model them as Entity-Relationship Diagrams (conceptual database design).;
4	Compare relational model with the Structured Query Language.;
5	Ability to realize a database project within a group.;

22	Course Content:

Week	Theoretical	Practical
1	Database Systems, file systems vs. a DBMS.	Working in Access 2007, Opening an Existing Database. Exploring tables, queries, forms, reports.
2	Schemas, queries, structures.	Creating a database, manipulating table columns and rows.
3	Introduction to Entity-Relationship Model.	Populating a database, importing information from another access database, excel worksheet, text file, dbase.
4	Entitles, attributes and entity sets.	Creating a form by using the form tool, entering data in a form by using vba.
5	Relationships and relationship sets, constraints, aggregation.	Creating a form by using an autoform, adding a subform to a form.
6	Introduction to the relational model. Creating and modifying relations, key constraints.	Sorting information in a table, filtering information in a table, filtering information by using a form.
7	Foreign key constraints, general constraints, querying relational data.	Creating a query manually, creating a query by using a wizard, performing calculations by using a query.
8	Entity sets to tables. Views, data independence, security, destroying/altering tables and views.	Restricting the type and amonunt of data in a field.
9	Relational algebra and calculus. relational algebra, selection and projection.	Relational algebra and calculus. relational algebra, selection and projection
10	Set operations, renaming, joins.	Preventing database problems.
11	Division relational calculus, tuple relational calculus, domain relational calculus.	Creating a report by using a wizard, modifying report design.
12	Introduction to SQL. Expressions and Strings in the SELECT Command. UNION, INTERSECT, and EXCEPT. Nested Queries.	Modifying report content, adding a subreport to a report.
13	Aggregate Operators. Embedded SQL.	Creating a switchboard, creating custom categories.
14	Dynamic SQL. Triggers and Active Databases.	Assigning a password to a database, securing a database for distribution.

23	Textbooks, References and/or Other Materials:	R. Ramakrishnan,J. Gehrke, Database Management Systems, McGraw-Hill Science/Engineering/Math; 3e, 2002 S. Lambert, M.D. Lambert, Microsoft® Office Access(TM) 2007 Step by Step, Microsoft Press, 2007
24	Assesment

TERM LEARNING ACTIVITIES	NUMBER	PERCENT
Midterm Exam	1	25
Quiz	0	0
Homeworks, Performances	1	25
Final Exam	1	50
Total	3	100
Contribution of Term (Year) Learning Activities to Success Grade		50
Contribution of Final Exam to Success Grade		50
Total		100
Measurement and Evaluation Techniques Used in the Course
Information

ECTS / WORK LOAD TABLE

Activites	NUMBER	TIME [Hour]	Total WorkLoad [Hour]
Theoretical	14	1	14
Practicals/Labs	14	2	28
Self Study and Preparation	14	2	28
Homeworks, Performances	1	2	2
Projects	1	15	15
Field Studies	0	0	0
Midtermexams	1	1,5	1,5
Others	0	0	0
Final Exams	1	1,5	1,5
Total WorkLoad			90
Total workload/ 30 hr			3
ECTS Credit of the Course			3

CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS

	PQ1	PQ2	PQ3	PQ4	PQ5	PQ6	PQ7	PQ12	PQ13	PQ14	PQ15
LO1	2	3	3	4	1	0	1	1	4	0	1
LO2	2	3	3	4	1	0	1	1	4	0	1
LO3	2	3	3	4	1	0	1	1	4	0	1
LO4	2	3	3	4	1	0	1	1	4	0	1
LO5	0	0	0	0	0	5	5	0	0	5	0

LO: Learning Objectives

PQ: Program Qualifications

Contribution Level:

1 Very Low

2 Low

3 Medium

4 High

5 Very High