60 %
40 %
Information about cecildb01

Published on December 13, 2007

Author: Marian

Source: authorstream.com

Recap:  Recap What is a database? How are databases different from spreadsheets? What is an ER Diagram? What basic representational structure do most commercial databases have? BC207: Data Management and Business Intelligence:  BC207: Data Management and Business Intelligence Cecil Eng Huang Chua Information Technology & Operations Management aehchua@ntu.edu.sg What is BC207?:  What is BC207? Lots of data Organize data Minimize error in the data Put data together to learn meaningful things Manage data Manage HUGE job of putting all that data together BC207 and Your Career:  BC207 and Your Career Single course that will get you a job Database administrator Secure as accounting Boring as hell Think in compartments Logical thinking jobs Technical Hot air Management job Digression: Most Important for a Business Major:  Digression: Most Important for a Business Major Talk (hot air) Write Think/Analyze Skills Do all in this course BC207 and the IT Major (1):  BC207 and the IT Major (1) FYP Do as continuation of project in this course Maybe extend from Web Technologies Course PA Certain PAs only open to IT students Technical=programming PA Managerial=“regular” PA BC207 and the IT Major (2):  BC207 and the IT Major (2) Enterprise Computing Data in the organization MANAGEMENT of data Web Technologies Implementation practice Linking application to DB Information Security Management Protecting the DB BC207 and the IT Major (3):  BC207 and the IT Major (3) Business Process Management MANAGEMENT of data Managing Manufacturing and Service Operations Based on data Consulting and Change Management Pretty pictures MANAGEMENT of data What’s the Course REALLY About?:  What’s the Course REALLY About? Database Technical Skills Management Training Lecture Lab Group Project Final Exam Lecture Games/Simulations Case Study Group Project Final Exam Technical Skills:  Technical Skills Conceptual data modeling Enhanced ER diagrams ER to Relational Logical data modeling (relational) Developing tables with controls Normalization Physical application development SQL Connecting to Programming Languages Management Training:  Management Training Saving IT’s Soul (Davenport) IS Project Control Dealing With Users IT Project Management Conceptualizing Technical Skills:  Conceptualizing Technical Skills Conceptual Model Logical Model Implementation ER Diagrams Relational Data Model Application Development Waterfall Model:  Waterfall Model Requirements Gathering and Analysis Design Implementation Maintenance Skills and Waterfall Model:  Skills and Waterfall Model Conceptual Model Requirements Logical Model Design Implementation Implementation Conceptualizing Management Training:  Conceptualizing Management Training IS Project Control Dealing with Users Project Management Database Course in IS vs. CE: Weeks of Lesson:  Database Course in IS vs. CE: Weeks of Lesson Material IS CE Project Management 3 0 ER 2 + 2 (113/213/201) 1 Decomposition 1 0.5 Relational Algebra 0.5* 1.5 Normalization 2 1 SQL 2 2 Screen Development 0.5 0 ODBC 0.5 1 Optimization 0 2 Concurrency 0 1 Access Control 0 1 To-do Today:  To-do Today Course Motivation Course Outline Administration Pacing Yourself Making Sense of IT (Lesson) Homework Books:  Books Books are optional Database: Design, Application, Development, & Administration (2nd edition) by Michael V. Mannino (McGraw-Hill) Systems Analysis and Design Methods (6th edition) by Jeffrey L. Whitten, Lonnie D. Bentley, and Kevin C. Dittman. (McGraw-Hill) The Books and the Course:  The Books and the Course Technical Database Issues The Book The Course Management Database Issues The Course Your Instructor:  Your Instructor Room: S3-B2A-16 Tel #: 6790-5666 E-mail: aehchua@ntu.edu.sg Office hours: I’m in most of time Grading:  Grading Individual Participation 5% Quizzes (up to 3 surprise) 20% Group Project 25% Groups of 3 Final Exam 50% Individual Participation:  Individual Participation Marked at every class Especially on case discussion days Get points: say something insightful Lose points: I cold call and you demonstrate ignorance of reading Quizzes:  Quizzes Unannounced Really Hard Curved Extra Credit Project:  Project Database case Choose either: Doctoral Tracking Database Education Store Insulation Unlimited Company Real world problem Use MS Access/Oracle End of semester presentation Points Breakdown:  Points Breakdown ER Diagram: 25 Normalization: 25 Screens: 20 Project Management Report: 20 Presentation: 10 Peer Evaluation: Adjustment Report:  Report Up to 500 word essay Describe management issues encountered in project Hardest 20 points to earn Ask your seniors Graded for content, style and One point deducted for: Each misspelled word Each grammatically incorrect sentence Each improper use of punctuation Can get a negative score Grading Mechanism:  Grading Mechanism No ceilings or floors Can get over 100% on any assessment Can get negative score on any assessment Exception: Final class score between 0 to 100 Final exam score between 0 to 100 Extra Credit Extra Credit:  Extra Credit Help me with simulations Two groups only Fun Quizzes Project Implement real system Develop full screen Impress me Extra Credit: Project (1):  Extra Credit: Project (1) Course scheduling system for NBS Goh Chern Nee, Jenny Soo Siew Mei, Allison Must commit to project as FYP Grading 10 points extra credit Only graded on own performance Project SNAFUs will not impact your grade Extra credit negotiable (lowest bidder) Extra Credit: Project (2):  Extra Credit: Project (2) # of groups Unlimited Extra credit=bid of lowest bidding group Compete with each other to deliver Course deliverables Design diagrams of system Preliminary code for one screen Project management report FYP deliverable Working system Grade Distribution:  Grade Distribution Bi-modal distribution Do really well Do really badly Final Exam:  Final Exam Content ER Modeling Translate ER to Relational Normalization SQL Database Management Case All questions mandatory To-do Today:  To-do Today Course Motivation Course Outline Administration Pacing Yourself Introducing Databases (Lesson) Surviving the course:  Surviving the course Long distance running Get to finish line, you’ll get at least a B Slip one milestone- in trouble Slip two milestones- you die Project requires 12 weeks to complete Nothing to Do:  Nothing to Do You’re doing something wrong ER Diagram is probably wrong 500 Word Essay isn’t good enough Have you checked your relational model? Have you debugged your screen? Check with me Proposed Project Schedule:  Proposed Project Schedule Week 1: Form groups Week 2: Select Case Weeks 3-7: ER Diagram Week 6-7: Write essay Week 7-8: Translate to Relational tables/Redraft essay Week 9-12: Screen Design/Redraft essay Remember your other classes have projects too. Last semester’s groups:  Last semester’s groups Project demo Non-Group Collaboration:  Non-Group Collaboration May seek outside assistance Must demonstrate self-competence Help on group projects Ok to ask for outside help Must be able to discuss and perform by yourself No assistance for in-class assessment Attendance:  Attendance Optional However Class participation score Correlation with skill development Story of the goose Better to be early than late Better to be late than absent Q&A:  Q&A Check Names To-do Today:  To-do Today Course Motivation Course Outline Administration Pacing Yourself Introducing Databases (Lesson) To-do Today:  To-do Today Data vs. Information Defining Databases The Data Modeling Process (Break) ER Models Revisited Data vs. Information:  Data vs. Information Data Facts Words, numbers, pictures etc. First Name=‘John’, Last Name=‘Smith’, Birthday=‘January 1, 1970’ Stuff we want to capture Information Process data so it is used When’s John’s birthday? We want to plan a party Why Do We Need Data?:  Why Do We Need Data? Transaction Processing Buying food at supermarket Command and Control Which department is performing well? Decision Making How many widgets should we make today? Why Do We Need a Database?:  Why Do We Need a Database? Organize Data How many items sold in A supermarket A supermarket chain Across Singapore? Organizing Data:  Organizing Data Why Share it Reduce duplication (redundancy) Reduce errors (integrity) Infer new things Why Not Privacy Power To-do Today:  To-do Today Data vs. Information Defining Databases The Data Modeling Process (Break) ER Models Revisited Database Characteristics:  Database Characteristics Data in a database is: Persistent Shared Interrelated Examples of Real-World Databases:  Examples of Real-World Databases The Database Management System (DBMS):  The Database Management System (DBMS) Mechanisms to Store data Retrieve data Change data Define data Present data Database vs. DBMS Supermarket database MSAccess DBMS Database Parts:  Database Parts To-do Today:  To-do Today Data vs. Information Defining Databases The Data Modeling Process (Break) ER Models Revisited Four Steps in Database Design:  Four Steps in Database Design Requirements Elicitation Conceptual Data Modeling Logical Data Modeling Implementation Requirements Elicitation:  Requirements Elicitation Talk to user Vs. Requirements Analysis Writing down user requirements Making sure they are correct and complete (ER Models) Where you learn BC203 In this class: one module In this class: two exercises Conceptual Data Models:  Conceptual Data Models ER EER UML NIAM/ORM Several thousand other models Logical Data Models:  Logical Data Models Relational Flat Files Hierarchical Network Pseudo-Relational Object-Oriented Implementation Systems (Relational):  Implementation Systems (Relational) DBase DB2 Informix Ingres Oracle MS Access MySQL (free) Many others Break:  Break Q&A

Add a comment

Related presentations