Organizational Database Management

1
Organizational Database Management

• CIS 458
• Introduction

2
Instructor

• Name Long He
• Office YR 431
• E-mail lhe_at_towson.edu
• Home page http//triton.towson.edu/lhe

3
Class

• Room YR401
• Hours 700 940 pm Tuesday
• Office Hours 500 600 Monday, Tuesday or By
  Appointment

4
Text Book

• Database Systems (Forth Edition)
• A practical Approach to Design, Implementation,
  and Management
• Author Thomas Connolly, Carolyn Begg
• Publisher Addison Wesley
• ISBN 0-321-21025-5

5
Course Objectives

• The primary objective of this course is to learn
  to design database applications for business
  enterprises and to learn how to use a relational
  database.
• Topics include user requirement analysis, logical
  database design, database systems architecture,
  entity-relationship model, SQL, normalization,
  and security.

6
Course Requirements

• 1. Required readings
• Relevant chapters of the text book.
• Additional Readings handed out in class.
• 2. Assignments
• There will be 6 assignments in this course.
• 3. Deliverables
• All assignments submitting should look
  professional. Pages should be typed, not
  handwritten.
• Please hand in homework on time
• The due time is the beginning of the class.

7
Course Requirements

• Class Participation
• 4 pop quizzes
• Drop 1 and count only 3
• Attendance

8
Project Report

• Business Analysis
• Project Objectives
• Problem Statement
• The current system and improvements.
• Initial Scope of the project
• Software, hardware
• Business functions
• Potential queries.
• Cost Benefit analysis
• Feasibility analysis
• Business Constraints
• Recommendation

9
Project Report

• Screen Shots
• Design all the screen shots
• Input screens, output screens, buttons, lists
• ER Diagram
• Extended ER diagram
• Relational database schema
• List all the possible questions for the database
• Normalization

10
Project Report

• Logical Database Design
• SQL Query

11
Project Report

• Final Project Report
• Working Database Software
• A pamphlet for the database
• Target business
• Software functions
• Advantages/limitations
• Users manual
• Screen shots
• Functional explanation
• Walkthrough (sample run)

12
Examinations

• There will be 2 closed book in-class tests.
• Midterm, Final
• Test Questions Types
• Problem solving questions
• Multiple choices
• Fill the blank type
• Short essay questions.

13
Grading

• 2 Exams 45
• 1st . 20
• 2nd 25
• 6 Assignments .... 30
• Each . 5
• 1 Project .. 19
• 1st presentation .. 5
• 2nd report . 2
• 3rd report . 2
• 2nd presentation .10
• 3 Pop Quizzes 6
• Each 2

14
Grading
15
Student Academic Integrity Policy

• Students are obligated not to violate the basic
  standards of integrity.
• Example
• Plagiarism
• Cheating

16
Student Introduction

• Name
• Computer skills
• Access, C, Oracle, SQL, and others.
• Computer related job experience (if you have any)

17
Form Your Group

• 3 - 4 Members
• Preferred group meeting time. (e.g. Week days,
  Weekends, morning, evening, etc)
• Please hand in the group information form