1 / 23

Organizational Database Management

Organizational Database Management. CIS 458 Introduction Sungchul Hong. Professor. Name: Sungchul Hong Office: YR 478 E-mail: shong@towson.edu Telephone: 410-704-6338 Home page: http://www.towson.edu/~shong. Class. Room: YR205 Hours: 7:00 – 9:40 P.M. Tuesday

kimberly
Download Presentation

Organizational Database Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Organizational Database Management CIS 458 Introduction Sungchul Hong

  2. Professor • Name: Sungchul Hong • Office: YR 478 • E-mail: shong@towson.edu • Telephone: 410-704-6338 • Home page: http://www.towson.edu/~shong

  3. Class • Room: YR205 • Hours: 7:00 – 9:40 P.M. Tuesday • Office Hours: 5:00 – 6:00 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

  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 administration, database systems architecture, entity-relationship model, SQL, normalization, and database security.

  6. IT Jobs

  7. DBA • Database Administrator (DBA): responsible for the planning, implementation, configuration, and administration of relational database management systems. Database administrators are normally proficient with one or more popular database software packages, such as Oracle or Microsoft SQL Server, and are normally familiar with one or more database query languages, such as SQL or MySQL. Database administrators sometimes hold certifications such as Certifed Oracle Database Administrator.

  8. Database Analyst • Database Analyst: responsible for designing and developing an organization's data flow models and database architecture. Although a database analyst may sometimes share administrative responsibilities with database administrators, analysts are normally responsible for designing the database schema which an organization will use to store and move business-critical data.

  9. ID Theft Symptom of Database Culture Big-Time Identity Theft Symptom of Databases That Amass Large Amount of Credit Card Numbers Database Helps Networks Catalog Ad Info ABC, CBS, NBC, Fox Use Internet-Accessible Database to Catalog Information on Advertisements

  10. Cops Test Handheld Fingerprint Reader Minnesota Police Field Testing Handheld Fingerprint Reader Database Checks Find Woman on Watch List U.S. Border Agent Used Multiple Databases to Check Woman on Watch List, Leading to Arrest

  11. 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. Assignments include one case, programming, design, and individual writings. Students are expected to use the Oracle DBMS and Microsoft Access for the SQL programming. • 3. Deliverables • All materials submitted for this course should look professional. Pages should be typed, not handwritten. • Late penalty: 20% per day. Please hand in HWs on time • The due time is at the beginning of the class.

  12. Course Requirements • Class participation • 4 pop quizzes • Drop 1 and count only 3 • Attendance/class participation

  13. Project Report • Report 1 • 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

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

  15. Project Report • Report 4 • Working Database Software(*) • A pamphlet for the database • Target business • Software functions • Advantages/limitations • User’s manual • Screen shots • Functional explanation • Walkthrough (sample run)

  16. Examinations • There will be 2 closed book in-class tests. • Midterm (20%), Final (25%) • Test questions Types • problem solving questions • Multiple choices • Fill the blank type • Short essay questions.

  17. Grading • 2 Exams ………………….. 45% • 1st …………. 20% • 2nd ………… 25% • 6 Assignments …………… 30% • Each ………. 5% • 1 Project …………………..15% • 1st report & presentation .. 5% • 2nd report & presentation .10% • Class participation ………….10% • 3 pop quizzes 6% (2% each) • Attendance 4%

  18. Grading

  19. Student Academic Integrity Policy • Students are obligated not to violate the basic standards of integrity. • Example • Plagiarism • Cheating

  20. Tentative Class Schedule • Please check the handout.

  21. Student Introduction • I’ll call your name. • Name • Preferred group meeting time. (e.g. Week days, Weekends, morning, evening, etc) • Computer skills • Access, C++, Oracle, SQL, MS SQL, and others. • Computer related job experience (if you have any)

  22. Form Your Group • 4 Members • Please hand in the group information form

More Related