Recap

1
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?

2
BC207 Data Management and Business Intelligence
Cecil Eng Huang Chua Information Technology
Operations Management aehchua_at_ntu.edu.sg
3
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

4
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

5
Digression Most Important for a Business Major

• Talk (hot air)
• Write
• Think/Analyze
• Skills

• Do all in this course

6
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
• Technicalprogramming PA
• Managerialregular PA

7
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

8
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

9
Whats the Course REALLY About?
Database
Technical Skills
Management Training
Lecture Lab Group Project Final Exam
Lecture Games/Simulations Case Study Group
Project Final Exam
10
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

11
Management Training

• Saving ITs Soul (Davenport)
• IS Project Control
• Dealing With Users
• IT Project Management

12
Conceptualizing Technical Skills

• Conceptual Model
• Logical Model
• Implementation

ER Diagrams Relational Data Model Application
Development
13
Waterfall Model

• Requirements Gathering and Analysis
• Design
• Implementation
• Maintenance

14
Skills and Waterfall Model

• Conceptual Model Requirements
• Logical Model Design
• Implementation Implementation

15
Conceptualizing Management Training
IS Project Control
Dealing with Users
Project Management
16
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

17
To-do Today

• Course Motivation
• Course Outline
• Administration
• Pacing Yourself
• Making Sense of IT (Lesson)
• Homework

18
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)

19
The Books and the Course
Technical Database Issues
The Book
The Course
Management Database Issues
The Course
20
Your Instructor

• Room S3-B2A-16
• Tel [phone]
• E-mail aehchua_at_ntu.edu.sg
• Office hours Im in most of time

21
Grading

• Individual Participation 5
• Quizzes (up to 3 surprise) 20
• Group Project 25
• Groups of 3
• Final Exam 50

22
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

23
Quizzes

• Unannounced
• Really Hard
• Curved
• Extra Credit

24
Project

• Database case
• Choose either
• Doctoral Tracking Database
• Education Store
• Insulation Unlimited Company
• Real world problem
• Use MS Access/Oracle
• End of semester presentation

25
Points Breakdown

• ER Diagram 25
• Normalization 25
• Screens 20
• Project Management Report 20
• Presentation 10
• Peer Evaluation Adjustment

26
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

27
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

28
Extra Credit

• Help me with simulations
• Two groups only
• Fun
• Quizzes
• Project
• Implement real system
• Develop full screen
• Impress me

29
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)

30
Extra Credit Project (2)

• of groups
• Unlimited
• Extra creditbid 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

31
Grade Distribution

• Bi-modal distribution
• Do really well
• Do really badly

32
Final Exam

• Content
• ER Modeling
• Translate ER to Relational
• Normalization
• SQL
• Database Management Case
• All questions mandatory

33
To-do Today

• Course Motivation
• Course Outline
• Administration
• Pacing Yourself
• Introducing Databases (Lesson)

34
Surviving the course

• Long distance running
• Get to finish line, youll get at least a B
• Slip one milestone- in trouble
• Slip two milestones- you die
• Project requires 12 weeks to complete

35
Nothing to Do

• Youre doing something wrong
• ER Diagram is probably wrong
• 500 Word Essay isnt good enough
• Have you checked your relational model?
• Have you debugged your screen?
• Check with me

36
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.

37
Last semesters groups

• Project demo

38
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

39
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

40
QA

• Check Names

41
To-do Today

• Course Motivation
• Course Outline
• Administration
• Pacing Yourself
• Introducing Databases (Lesson)

42
To-do Today

• Data vs. Information
• Defining Databases
• The Data Modeling Process
• (Break)
• ER Models Revisited

43
Data vs. Information

• Data
• Facts
• Words, numbers, pictures etc.
• First NameJohn, Last NameSmith,
  BirthdayJanuary 1, 1970
• Stuff we want to capture
• Information
• Process data so it is used
• Whens Johns birthday? We want to plan a party

44
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?

45
Why Do We Need a Database?

• Organize Data
• How many items sold in
• A supermarket
• A supermarket chain
• Across Singapore?

46
Organizing Data

• Why
• Share it
• Reduce duplication (redundancy)
• Reduce errors (integrity)
• Infer new things
• Why Not
• Privacy
• Power

47
To-do Today

• Data vs. Information
• Defining Databases
• The Data Modeling Process
• (Break)
• ER Models Revisited

48
Database Characteristics

• Data in a database is
• Persistent
• Shared
• Interrelated

49
Examples of Real-World Databases
50
The Database Management System (DBMS)

• Mechanisms to
• Store data
• Retrieve data
• Change data
• Define data
• Present data
• Database vs. DBMS
• Supermarket database
• MSAccess DBMS

51
Database Parts
52
To-do Today

• Data vs. Information
• Defining Databases
• The Data Modeling Process
• (Break)
• ER Models Revisited

53
Four Steps in Database Design

• Requirements Elicitation
• Conceptual Data Modeling
• Logical Data Modeling
• Implementation

54
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

55
Conceptual Data Models

• ER
• EER
• UML
• NIAM/ORM
• Several thousand other models

56
Logical Data Models

• Relational
• Flat Files
• Hierarchical
• Network
• Pseudo-Relational
• Object-Oriented

57
Implementation Systems (Relational)

• DBase
• DB2
• Informix
• Ingres
• Oracle
• MS Access
• MySQL (free)
• Many others

58
Break

• QA