Click to Print This Page
Code CS 306
Term 201602
Title Database Systems
Faculty Faculty of Engineering and Natural Sciences
Subject Computer Sci.& Eng.(CS)
SU Credit 3
ECTS Credit 6.00 / 6.00 ECTS (for students admitted in the 2013-14 Academic Year or following years)
Instructor(s) Yucel Sayg?n -ysaygin@sabanciuniv.edu,
Language of Instruction English
Level of Course Undergraduate
Type of Course Click here to view.
Prerequisites
(only for SU students)
CS201
Mode of Delivery Formal lecture,Recitation
Planned Learning Activities Interactive,Communicative,Project based learning,Other
Content

This course covers the fundamental topics in database management systems including ANSI/SPARC architecture, data abstraction, data independence; data definition and manipulation languages; entity-relationship and relational data models, integrity constraints, query languages like SQL, relational algebra and calculus, functional dependencies, normal forms, transaction processing recovery and concurrency control, data structure for database management systems such as indices, B-trees, hashing.

Objective

To supply the students with the theory and practice of database management systems, and database application development.

Learning Outcome

After this course, the student will be able to develop a database application starting with the conceptual design leading to logical and physical designs.
After the course, the student will be competent on relational model and SQL.
After the course, the student will be able to implement a database application based on a given design.
After the course, the student will be able explain the concept of functional dependency and will be able to avoid redundancies and other problems causing by bad designs.
After the course, the student will be able to explain how a DBMS concurrently handles the transactions and what happens after a system crash.
After the course, the student will be able to explain how the data is physically stored, managed, and queried within the database.

Programme Outcomes
 
Common Outcomes For All Programs
1 Understand the world, their country, their society, as well as themselves and have awareness of ethical problems, social rights, values and responsibility to the self and to others. 1
2 Understand different disciplines from natural and social sciences to mathematics and art, and develop interdisciplinary approaches in thinking and practice. 1
3 Think critically, follow innovations and developments in science and technology, demonstrate personal and organizational entrepreneurship and engage in life-long learning in various subjects. 1
4 Communicate effectively in Turkish and English by oral, written, graphical and technological means. 1
5 Take individual and team responsibility, function effectively and respectively as an individual and a member or a leader of a team; and have the skills to work effectively in multi-disciplinary teams. 1
Common Outcomes ForFaculty of Eng. & Natural Sci.
1 Possess sufficient knowledge of mathematics, science and program-specific engineering topics; use theoretical and applied knowledge of these areas in complex engineering problems. 1
2 Identify, define, formulate and solve complex engineering problems; choose and apply suitable analysis and modeling methods for this purpose. 4
3 Develop, choose and use modern techniques and tools that are needed for analysis and solution of complex problems faced in engineering applications; possess knowledge of standards used in engineering applications; use information technologies effectively. 5
4 Ability to design a complex system, process, instrument or a product under realistic constraints and conditions, with the goal of fulfilling specified needs; apply modern design techniques for this purpose. 3
5 Design and conduct experiments, collect data, analyze and interpret the results to investigate complex engineering problems or program-specific research areas. 1
6 Knowledge of business practices such as project management, risk management and change management; awareness on innovation; knowledge of sustainable development. 1
7 Knowledge of impact of engineering solutions in a global, economic, environmental, health and societal context; knowledge of contemporary issues; awareness on legal outcomes of engineering solutions; understanding of professional and ethical responsibility. 1
1 Formulate and analyze problems in complex manufacturing and service systems by comprehending and applying the basic tools of industrial engineering such as modeling and optimization, stochastics, statistics.
2 Design and develop appropriate analytical solution strategies for problems in integrated production and service systems involving human capital, materials, information, equipment, and energy.
Industrial Engineering Program Outcomes Core Electives
3 Implement solution strategies on a computer platform for decision-support purposes by employing effective computational and experimental tools. 3
Computer Science and Engineering Program Outcomes Core Electives
1 Design, implement, test, and evaluate a computer system, component, or algorithm to meet desired needs and to solve a computational problem. 3
2 Demonstrate knowledge of discrete mathematics and data structures. 3
3 Demonstrate knowledge of probability and statistics, including applications appropriate to computer science and engineering. 1
1 Comprehend key concepts in biology and physiology, with emphasis on molecular genetics, biochemistry and molecular and cell biology as well as advanced mathematics and statistics.
2 Develop conceptual background for interfacing of biology with engineering for a professional awareness of contemporary biological research questions and the experimental and theoretical methods used to address them.
1 Applying fundamental and advanced knowledge of natural sciences as well as engineering principles to develop and design new materials and establish the relation between internal structure and physical properties using experimental, computational and theoretical tools.
2 Merging the existing knowledge on physical properties, design limits and fabrication methods in materials selection for a particular application or to resolve material performance related problems.
3 Predicting and understanding the behavior of a material under use in a specific environment knowing the internal structure or vice versa.
1 Familiarity with concepts in statistics and optimization, knowledge in basic differential and integral calculus, linear algebra, differential equations, complex variables, multi-variable calculus, as well as physics and computer science, and ability to use this knowledge in modeling, design and analysis of complex dynamical systems containing hardware and software components.
2 Ability to work in design, implementation and integration of engineering applications, such as electronic, mechanical, electromechanical, control and computer systems that contain software and hardware components, including sensors, actuators and controllers.
1 Use mathematics (including derivative and integral calculations, probability and statistics), basic sciences, computer and programming, and electronics engineering knowledge to design and analyze complex electronic circuits, instruments, software and electronics systems with hardware/software.
2 Analyze and design communication networks and systems, signal processing algorithms or software using advanced knowledge on differential equations, linear algebra, complex variables and discrete mathematics.
Assessment Methods and Criteria
  Percentage (%)
Midterm 65
Participation 5
Individual Project 20
Homework 10
Recommended or Required Reading
Readings

Ramakrishnan and Gehrke, Database Management Systems, McGraw Hill

Course Web http://people.sabanciuniv.edu/~kaya/CS306/spring15.html