COURSE OUTLINE

Report 4 Downloads 590 Views

DEPARTMENT OF COMPUTER SCIENCE. COLLEGE ... Understand the basic concepts, methods, and terminology used in database technology;. 2. Apply the ...

DEPARTMENT OF COMPUTER SCIENCE COLLEGE OF COMPUTER STUDIES ATENEO DE NAGA UNIVERSITY

COURSE OUTLINE Course Code Course Title Units Prerequisite(s) Term School Year Schedule Instructor Consultation Hours E-mail

ICST211 Database Management Systems 1 3 ICST102 First Semester 2010-2011 N2- 09:00AM-11:00AM/ 10:30AM-12:00NN P217/CSLAB2 N1- 11:00AM-12:00NN/ 09:00AM-10:30AM P217/CSLAB2 : Estrella H. Montealegre : 4:30 – 5:30PM TTH CS Department : [email protected] : : : : : : :

Course Description This course is the first part and an introductory module to database management systems, and the design and use of database systems. It provides the students with the background to design implement and use database systems. It covers the following aspects of database management systems:  The key points which characterize the database approach.  An introduction to the relational data model concepts  A comprehensive introduction to the database development process.  A brief introduction to the main implementation techniques of database management systems (DBMSs).  Structured query language (SQL)  An overview of the state of art database technology and applications. In addition, this course will outline some database technologies and applications that address new challenges to database and information management in general. The course consists of a lecture component and a laboratory component wherein students' theoretical knowledge is supplemented with hands-on exercises. Course Objectives At the end of this course, students should be able to 1. Understand the basic concepts, methods, and terminology used in database technology; 2. Apply the necessary principles associated with the analysis, development and implementation and maintenance of database systems; 3. Utilize database development tools including E-R diagrams, normalization process, and SQL fundamentals; 4. Develop the skills to analyze business requirements and produce a viable model and implementation of a database to meet such requirements.

Course Topics 1. The Database Environment

Week Week 1

2. 3. 4. 5.

The Database Development Process Modeling Data in the Organization Logical Database Design and Relational Model Basic SQL

Week 2 Week 3-5 Week 6-8 Week 9-11

Course Requirements Laboratory Exercises. Sets of exercises will be given to the students to reinforce learning and to provide challenging database management concepts. Major Exams. Students are expected to pass the major exams. Course Project. This course requires one project. The project is an individual work. Each student will choose an organization, where he or she will study the existing processes, identify problem areas, and carefully plan the database project to be developed. The student is required to follow the project stages presented below and submit appropriate documentation not later than the specified dates. Project Stage Project Proposal

-

Analysis Design Presentation

-

Deliverables formal request to conduct a project to design and develop a database system through a submitted copy of the project proposal Requirement Specification Design Specification Project Design Defense and Final Documentation

Due November 15, 2010

November 25, 2010 December 16, 2010 February 1-5, 2011

Grading Scheme Class Standing Quizzes Project Laboratory Exercises Prelim Exam Midterm Exam Pre-Final Exam Final Exam

40% 10% 20% 10%

TOTAL

10% 20% 10% 20% 100%

Textbook J. Hoffer, M. Prescott M, and F. McFadden, Modern Database Management, 7th Edition., Prentice Hall. 2002 References [1] C. Date, An Introduction to Database Systems, 7th Edition, Addison-Wesley Publishing Company, Inc., 2000 [2] A. Silberschatz, H. Korth, S. Sudarshan, Database System Concepts, 4th Edition, McGraw-Hill, 2002 [3] K. Loney, Oracle Database 10g: The Complete Reference, McGraw-Hill Companies, Inc., 2004

[4] T. Connolly, C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 4th Edition, Pearson, 2005 Web Support Tools and Resources [1] Lecture Notes and Exercises for Students. http://www.engrade.com/trelm [2] The Zachman Framework by David C. Hay – Information on Data Model and Data Development using the Zachman IS Architecture. http://www.essentialstrategies.com/publications/methodology/zachman.htm [3] SQL Tutorial. www.sqlcourse.com [4] Database Journals and Articles. http://www.databasejournal.com

Software Sources [1] Oracle Database 10g edition/downloads/index.html

Express

Edition.

http://www.oracle.com/technetwork/database/express-

Recommend Documents
Examples: kefir, yogurt, cultured vegetables. ◦ Fermented foods contain good bacteria ... Excess meat. - Gluten. - Excess sugars. ◦ What are some of the foods ...

Mar 24, 2019 - Chapter 11: Mobile Devices. Chapter 12: .... PCIe (Peripheral Component Interconnect Express). Chipsets ..... Installing memory modules.

Mar 26, 2018 - 70-410 Installing And Configuring Windows Server 2012 ... configuring server roles and features, deploying and configuring core network ...

Dec 22, 2016 - Award Winning Learning Platform (LMS). 8. Chapter & Lessons ... uCertify has won CODiE awards consecutively for last 3 years: 2014. 1.

Chapter 28: Network Address Translation. Chapter 29: ... Chapter 31: Implementing IPv6 Addressing on Routers ..... Answers to Calculating IPv6 Prefix Problems.

tools to perform appraisal duties. Chapter One. Body structural parts and re-alignment. Overview: Frame damage is very common in collisions; there are various ...

Dec 18, 2016 - HIT-001 Labs - CompTIA Healthcare IT Technician. Labs ... cloud-based, device-enabled and can be easily integrated with an LMS. Features of ...

Apr 11, 2018 - Chapter 13: Troubleshooting IPv4 and IPv6 ACLs and Prefix Lists ... Gain hands-on expertise in Cisco CCNP certification exam with CCNP ... Over 800 unique questions including pre-assessment, quizzes, exercises, and post assessment. 4.

Network Segmentation. Honeypot. Endpoint Security. Group Policies. ACLs .... Initiating an SSH session from your Windows 10 client to your Windows Server.

This course covers the areas of information technology and computer literacy including history, basic ... The project will simulate all the knowledge that has.