Database Management Systems - Storage Problems and Database Design

1. Write this down! ISM 4212 Dr. Larry West http://systems.bus.ucf.edu/lwest lwest@bus.ucf.edu

2. Course Topics • ISM 4212 — Database Management Systems • "Design and implementation of relational databases in organizations" (UCF Undergraduate Catalog) • Additional topics • Database application design and implementation • Data warehousing • Database administration • Distributed databases

3. Storage Problems • Identify a storage problem that has nothing to do with information or data • What are the items to be stored? • What different approaches are taken by different people to store these items? • For each approach: • What are the costs? • What are the advantages? • What are the disadvantages? • Do advantages and disadvantages apply to placing items in storage, storage, or retrieval?

4. Database Design • All business information systems rely on stored data • Data can be stored efficiently or inefficiently • “Efficiency” applies to: • Act of placing data into storage • Storing data • Act of retrieving data • Act of modifying data • There are often tradeoffs • Easier storage makes for harder retrieval • Etc.

5. Database Design (cont.) • "Efficiency" depends on many factors • Type of data • Capabilities of computer hardware • Capabilities of database management system (DBMS) • Access & user needs • Data volume • Transaction frequency and nature • Design decisions create costs and benefits • Database designer creates the data structures used by applications • These enable storage and retrieval

6. Database Designers • Database design is a key element in any information system • Database designers must understand the business's processes to design effective databases • Effectively analyzing organizational data needs and designing effective structures is where you will make your money in the early years of your careers

7. Prerequisites • ISM 3253 is an absolute and unwaiverable prerequisite • Group project requires implementation in VB • VB will be the example language used in client server presentations • If you do not meet this prerequisite you should go ahead and leave now.

8. What’s Different About this Course • To succeed in this course you must perform the same tasks you will perform on the job as an MIS professional • Understand problems and design solutions • Translate specifications from someone else into a finished requirement • Learn techniques with some learning on your own • Recognize how to adapt techniques learned for one use to another similar use

9. What’s Different About this Class (cont.) • You have no right to a good grade in this class, even if you show up every day • You are responsible for understanding the material, memorizing it just won’t work • You are responsible for managing your efforts • Backing up your projects • Having time to coordinate with the instructor • Planning time to study and complete the projects • You must have time to use the lab or your own computer for projects

10. What’s Different About this Course (cont.) • While the class has lots of theory in it the theory is all applied • Your group project or SQL either works or it doesn’t • Your answer is either right (it works) or its wrong (it doesn’t) • I will evaluate you as if you worked for me and your work becomes part of what I give my boss You are past the general background part of your educations now

11. How to Succeed . . . • Don’t see memorization as the goal • Allow knowledge to embed itself through use • Be able to recognize why a step is used or suggested • Thoroughly understand the problem you are dealing with — be able to solve it with pencil and paper before you attempt to implement the solution • Allow adequate time to complete assignments • Allow adequate time to get help from the instructor when you are stuck • Practice techniques we cover in class right away • Coordinate with the instructor

12. How to Succeed (cont.) • Work effectively with your team • Divide responsibility • Keep each other informed • Do your part on time and expect your team members to do the same • Get the fundamental skills under control early • Practice • Experiment

13. What I’m Assuming About You • You understand basic Windows tasks • Editing • Saving, opening, copying, moving, and deleting files • You understand the fundamentals of programming • You have time in your schedule to complete the assignments and work with your group • You understand how to use e-mail and the Web or will learn quickly • You have access to computer and software • See “Textbook” link on course page

14. What You Can Assume About Me • I understand this material • I won’t try to trick you • I want you to succeed • I will give you the grade you earn • I will be available to you as described in the syllabus except for announced absences

15. Grading

16. Grading Weights

17. Grade Distribution Fall 2008 A 9 A- 6 B+ 2 B 10 B- 2 C+ 2 C 8 C- 4 D 4 F 7

18. Problem Grades

19. Admin Stuff • Attendance • About the text books and software • Using the Web Site • Using e-mail • Registering • Lab Overview

20. Write this down! ISM 4212 Dr. Larry West http://systems.bus.ucf.edu/lwest lwest@bus.ucf.edu