Transcript
ITM113 – Database Management Systems Updated: 3/4/08 School: Department:
Golden Gate University Computer Information Systems
Term:
Summer 2008
Course Number: ITM113 Day/Time: CyberCampus SF1 – Monday 6:50-9:30 5/5/08 – 6/23/08 Office: Via GGU CyberCampus Discussion Sessions.
Instructor: E-mail:
Karen Chen Phone: (510) 483-3725 Use GGU CyberCampus for class related messages
[email protected] (for personal messages and messages with attachments) Required Text: 1. Database Processing: Fundamentals, Design, and Implementation. 10th Ed. By David M. Kroenke 2. A Guide to SQL by Pratt Course Description: ITM113 – Database Management Systems– (3 units) Provides a solid foundation in database management systems, concentrating on the benefits, structures and views of data. You will analyze the existing database design methodologies while using Oracle and SQL. Prerequisites: ITM 10 Small Computers for Business or consent of the Department Chair. All Bachelor degree students in Information Technology must have an academic background that includes the computer proficiency skills listed below: • Windows working knowledge (Windows ME, Windows 2000, XP or other similar operating system) • Working knowledge of Word Processing (MS Word or equivalent) • Working knowledge of Spreadsheets (MS Excel or equivalent) • Working knowledge of Browsers such as Netscape, Windows Explorer or equivalent. • Working knowledge of Text Editors such as Notepad++, WordPad or equivalent. • Printing a file after configuring your printer. • Creating, deleting and renaming a file. • Creating a subdirectory, a file in a subdirectory, copying a file to a subdirectory. • Working knowledge of TELNET or equivalent such as PuTTy or TERA TERM PRO. • Working knowledge of FTP or equivalent such as FileZilla or WS-FTP. • Own a computer at home for course assignments and homework or have access to a computer for homework. • Have an email account for course assignments. Please talk to me if you think that you do not satisfy the course pre-requisites. Course Outcomes: Students who successfully complete this course will have the following skills: • Working knowledge of the Relational model • Ability to create and use an Entity-Relationship Model (ERD) • Ability to understand and use normalization • Ability to design a relational database from an ERD • Working knowledge of Structured Query Language (SQL) • Ability to create and drop tables in a relational database • Ability to insert, delete and update records in a relational database • Ability to use built-in functions for computations, dates, string and data type transformations • Ability to create and execute SQL scripts • Ability to create business reports using SQLPLUS • Working knowledge of ORACLE • Ability to use ORACLE on a UNIX server • Ability to develop, implement and document a small-scale database project using Oracle for a business organization Getting Help: The best way for you to get your questions answered or to obtain help with your assignment is to post questions to the GGU CyberCampus. I will monitor the class threads and respond as soon as I can. Course Policies: No late assignment will be accepted. Make arrangements to hand in your assignment early if you will not be able to attend the class.
ITM113 – Database Management Systems Updated: 3/4/08 Academic Honesty: All students are required to read and adhere to the Golden Gate University Policy on Academic Honesty (http://internet.ggu.edu/student_affairs/griffin/cheating.html). Any form of cheating will result in receiving an ‘F’ for the course. Grading: Course work will be weighted to determine your final course grade for ITM113 as follows: On-line Discussion 30% Homework 40% Final 30% The final course Grade is based on a four-point scale. Final grade values are assigned as follows: Comments Letter Percentage Achievement Grades Reserved for outstanding students. Work well above A+ 97% < score <= 100% A
94% < score <= 96%
AB+ B BC+ C
90% < score <= 93% 87% < score <= 89% 84% < score <= 86% 80% < score <= 83% 77% < score <= 79% 74% < score <= 76%
CD+ D DF
70% < score <= 73% 67% < score <= 69% 64% < score <= 66% 60% < score <= 63% 0% < score <= 59%
expectations. Superior work in quality and quantity. Student produces more than requested or expected. Superior work Average work Average work. Student only does what is requested. Average work. Below average. Bellow average. Work is bellow expectation in quantity and/or quality in some areas. Bellow average Deficient work. Deficient work in quantity and/or quality in almost all areas. Deficient work Failing. Student presents unacceptable work in quality and quantity, late work, almost no class participation
GOLDEN GATE UNIVERSITY Policy on incomplete (“I”) and withdraw (“W”) grades: incomplete grades are awarded only under unusual circumstances involving medical or “personal emergencies.” Your work responsibilities outside of class do not constitute personal emergencies. It is your responsibility to contact me as soon as possible to formally request an incomplete grade. Absolutely no incomplete grades will be awarded after the semester is over. If you stop attending class, you must formally drop the course to receive a “W” grade during the official drop period. If you have to miss an examination due to an emergency, please contact me prior to the exam date. Make-up examinations will only be given for what consider to be valid emergencies. No exceptions. If you have any problems related to the class work, please contact me as soon as possible. Instructor Biography: Ms. Chen is an Adjunct Professor of Computer Information Systems at Golden Gate University. She has over 25 years of industry experience and has worked in a number of software engineering and management positions for companies including Hewlett-Packard, Sony Corp of America, and Bell Northern Research. Ms. Chen also consulted for Pacific Bell as well as co-founded Adisoft, Inc., a software company. In addition to teaching at GGU, she consults for a startup software company, which she is the co-founder, on project basis. Ms. Chen has a BS degree in Computer Information Science from University of California, Irvine, a MS IT from Golden Gate University, and MBA from Golden Gate University. Session Topics: Read assigned chapters before class.
ITM113 – Database Management Systems Updated: 3/4/08
1.
2. 3. 4. 5. 6. 7.
8.
Read
Assignments
Getting Started Section Kroenke: Chapter1 Introduction Pratt: Chapter 1: Introduction to Database Cases Kroenke: Chapter 2: Introduction to Structured Query Language Pratt: Chapter 2 An Introduction to SQL Krnoenke: Chapter 3:The Relational Model and Normalization Pratt: Chapter 3 Single-Table Queries Krnoenke: Chapter 4: Database Using Normalization Pratt: Chapter 4 Multiple-Table Queries Kroenke: Chapter 5:Data Modeling with ER Model Pratt: Chapter 5 Updating Data Kroenke: Chapter 6:Transfering Data Models into Database Designs Pratt: Chapter 6 Database Administration Kroenke: Chapter 7: SQL for Database Construction and Application Processing Pratt: Chapter 7 Reports Final
Set up your PC as described in the Getting Started section. Complete Alexamara Marina Group exercises in Pratt Chapter 1. Complete Alexamara Marina Group exercises in Chapter 2. Complete Alexamara Marina Group exercises in Chapter 3 Complete Alexamara Marina Group exercises in Chapter 4 Complete Alexamara Marina Group exercises in Chapter 5. Complete Alexamara Marina Group exercises in Chapter 6. Complete Alexamara Marina Group exercises in Chapter 7.
