From Wikipedia, the free encyclopedia This page is based on a Wikipedia article written by Text is available under the CC BY-SA 4.0 license; additional terms may apply. Images, videos and audio are available under their respective licenses. Cover photo is available under {{::mainImage.info.license.name || Add your first bookmark by selecting some text or hovering over a link. Look for the bookmark icon. Already have this bookmark Date: {{(current.info.date | date:'mediumDate') || Uploaded by: {{current.info.uploadUser}} on {{current.info.uploadDate | date:'mediumDate'}} License: {{current.info.license.usageTerms || current.info.license.name || current.info.license.detected || View file on Wikipedia Thanks for reporting this video!The requested URL /mod/resource/view.php?id=3045 was not found on this server. Carlos Coronel and Steven Morris, “Database Systems: Design, Implementation, & Management, 11th Edition,” Cengage Learning, 2015, ISBN-13: 9781285196145.
Carlos Coronel and Steven Morris, “Database Systems Design, Implementation, and Management 11e,” Cengage Learning Asia, 2015. D. M. Kroenke, D. J. Auer, "Database Processing Fundamentals, Design, and Implementation, Eleventh Edition," Pearson Education Inc., 2010. J. A. Hoffer, M. B. Prescott, H. Topi, "Modern Database Management, Tenth Edition," Pearson Education, Inc., 2011. Useful WebSite and Info: This Course on quizlet Assignments & Class Participation in the 10th week in the 18th week Please turn off or mute our mobile phones before If you need to communicate with your neighbors, please keep If you need to come in late or leave earlier, do not interrupt the class or disturb your classmates. There is no stupid question! if you cannot follow me. Class Etiquette Rules 「教室禮儀」 Topics & Class Notes: Reading Assignment & Reference Website Part I: DATABASE CONCEPTS What is a Database?
What is a database? What are the Advantages of a DBMS? What types of Databases are there? Problems with File System Data Processing What is a Data Model? The Evolution of Data Modeling Different Types of Database Importance of Data Models What are the three parts involved in any SQL-based relational database application? Part II: DESIGN CONCEPTS 3. The Relational Database Model The History of the Relational Database 4. Entity Relationship (ER) Modeling Entity Relationship Diagram (ERD) Training Video 5. Advanced Data Modeling 6. Normalization of Database Tables What is Database & SQL? Data modelling - an introduction Part III: ADVANCED DESIGN AND IMPLEMENTATION 7. Introduction to Structured Query Language (SQL) demonstration of basic SQL commands for dummies Part IV: ADVANCED DATABASE CONCEPTS 10. Transaction Management and Concurrency Control Top 10 Mistakes in Data Management
11. Database Performance Tuning and Query Optimization MySQL Database Programming for Beginners 2015 13. Business Intelligence and Data Warehouses What is Business Intelligence? Benefits of a Data Warehouse What is an ETL Tool? What is the Information System? What are the five phases of The Systems Development Life Cycle? What are the six phases of the Database Life Cycle? What is Data Virtualization? Assignments & Class Participation: Assignments MUST be submitted via 靜宜大學網路學園. Again, NO LATE ASSIGNMENT will be accepted. Assignment 1: Self-Introduction with Goals and Objectives (3 points) Please provide one or two paragraphs of your self-introduction. Please provide your one-year, three-year and ten-year goals and objectives. Goals are the broad results that you want to achieve, the "destination" of your work. Objectives are the smaller steps that take you toward your goals, a "road map" to guide you to your destination.
Without a destination and a map to reach it, you won't get too far. Please provide your printed/digital photo. Name your homework as 1052DM-Assignment1.副檔名 (.doc, .ppt, .pdf, .html, etc.) Upload your assignment to http://elearning.pu.edu.tw (靜宜大學網路學園) Assignment 2: Data Models (3 points) Assignment 3: ER Modeling (3 points) Assignment 4: Normalization of Database Tables (3 points) Assignment 5: Structured Query Language (SQL) (3 points) Lab scores will be evaluated by your teaching assistants. More detail information, please contact your teaching assistants. Midterm exam will be in the 9th week's class, 9:10am-11:00am. Midterm exam will cover 3. The Relational Database Model. 4. Entity Relationship (ER) Modeling. 5. Advanced Data Modeling. 6. Normalization of Database Tables. Exam Questions: True/False Questions, and Filling question samples can be download at http://elearning.pu.edu.tw (靜宜大學網路學園)
Ch2 Problems: #4, #5, #6, #7, #8, #13, #14, #15 Ch3 Review Questions: #14, #18~ #21 Ch3 Problems: #10, #11, #12, #17~#23 Ch4 Review Questions: #5, #17~#21 Ch4 Problems: #1, #4 Ch5 Review Questions: #7, #8, #9 Ch5 Problems: #1, #2, #4 Ch6 Review Questions: #6, #7, #8 Ch6 Problems: #4, #6, #8, #9 It is a closed-book exam. However, you can carry with you. Final exam will be in the 18th week's class, 9:10am-11:00am. Final exam will cover 6. Normalization of Database Tables. (for short answer questions only) 7. Introduction to Structured Query Language (SQL). 10. Transaction Management and Concurrency Control. 13. Business Intelligence and Data Warehouses. Ch7 Problems: #26~#43 (based on Ch07_SaleCo.mdb) Ch8 Problems: #19~#22 (based on Ch08_LargeCo.mdb) Ch13 Problems: #5~#10 (based on Ch13-SaleCo-DW.mdb) Ch07_SaleCo.mdb, Ch08_LargeCo.mdb, Ch13-SaleCo-DW.mdb can be download at http://elearning.pu.edu.tw (靜宜大學網路學園)