This course gives students hands-on practice and experience in database design and administration along with the fundamental concepts and techniques involved. Topics covered include the entity-relationship model, relational database theory, file structure, indexing and hashing, query processing, crash recovery, concurrency control/transaction processing security and integrity. Creation of tables, views, synonyms and indexes are examined in detail. The use of SQL is considered and highlighted with the help of examples, and used to build the underlining database of an application. Topics include Introduction to RDMS; Database Creation and Modification; SQL; Event Programming; Multiple Module Applications; Database Architecture; Hardware Configuration and Consideration; Database Layouts; Database Management; Managing Rollback Segments; Database Tuning; Database Security and Auditing; Backup and Recovery Procedures.
Database Design, Management and Administration (IT 553)
| Programs\Type | Required | Core Elective | Area Elective |
| Information Technology - Non Thesis | * |
CONTENT
OBJECTIVE
Topics covered include the entity-relationship model, relational database theory, file structure, indexing and hashing, query processing, crash recovery, concurrency control/transaction processing security and integrity. Creation of tables, views, synonyms and indexes will be examined in detail. The use of SQL will be considered and highlighted with the help of examples, and used to build the underlining database of an application
LEARNING OUTCOMES
- at the end of the course the learner is expected to be able to transform end user business requirements into E-R diagrams, hence be able to complete the concetual design from requriements specifications. The logical design and physical design phases are also expected to be successfully done by the learner, moreover s/he is expected to be able to explain the differences, inputs and outputs of each phase in terms of the targets of this program (not detailed as a computer engineering initiated program)
PROGRAMME OUTCOMES
1. Develop the ability to use critical, analytical, and reflective thinking and reasoning 5
2. Reflect on social and ethical responsibilities in his/her professional life. 2
3. Gain experience and confidence in the dissemination of project/research outputs 3
4. Work responsibly and creatively as an individual or as a member or leader of a team and in multidisciplinary environments. 4
5. Communicate effectively by oral, written, graphical and technological means and have competency in English. 4
6. Independently reach and acquire information, and develop appreciation of the need for continuously learning and updating. 5
1. Design and model engineering systems and processes and solve engineering problems with an innovative approach. 5
2. Establish experimental setups, conduct experiments and/or simulations. 4
3. Analytically acquire and interpret data. 5
1. Identify the communication requirements in the corporate infrastructure, design and implement a capable and expandable solution. 5
2. Apply fundamental programming concepts to produce the source code by enforcing the correct syntax and semantics. 4
3. Customize, debug and test the code. 2
4. Design and implement a database system suitable for the requirements of the project. 5
5. Conduct project planning, management and coordination; prioritize resources and activities for on-time and on-budget project delivery. 5
Update Date:
ASSESSMENT METHODS and CRITERIA
| Percentage (%) | |
| Final | 55 |
| Midterm | 30 |
| Quiz | 10 |
RECOMENDED or REQUIRED READINGS
| Textbook |
Fundamentals of Database Systems (Elmasri & Navathe) |
| Readings |
some of the students asked for Turkish Resources. Physical database design the database professional's guide to exploiting indexes, views, storage, and more A survey on data and Transaction management in Mobile Databases https://sucourse.sabanciuniv.edu/access/content/group/IT553-201401/ASurvey%20on%20Data%20and%20Transaction%20management%20in%20mobile%20databases-2012.pdf A Relational Model of Data for Large Shared Data Banks |
| Optional Readings |
http://dev.mysql.com/doc/refman/5.1/en/ansi-diff-transactions.html http://wikidba.wordpress.com/2014/12/05/top-tips-to-maintain-the-security-of-database-environment/ the most informative weekly newsletter about SQL http://www.databaseweekly.com/ Database design and implementation is the cornerstone of any data centric project (read 99.9% of business applications) and should be treated as such when you are developing. This article, is about Ten Common Database Design Mistakes https://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/ a post on database comparison http://www.thegeekstuff.com/2010/03/top-5-best-databases/ Microsoft AND Oracle Are Now More Valuable Than IBM The $3 Billion Reason Why Oracle Is Nearing Its All-Time High (ORCL) Data Is Crazier than You Think https://asktom.oracle.com |