MIS 340 Principles of Database Systems
Fall 2017
Class
Venue:BDC 163
Home page:
Instructor
Name:Yong Choi, PhD
Office:BDC 103
Office Hours:Tuesday (3:30pm – 5:30pm)
Thursday (3:30pm – 5:30pm)
Or by an appointment
Office Phone: 661 - 654 - 6691
Email Address:
Course Description
This course introduces the fundamental concepts and implementations of the relational database systems as well as basic knowledge of geodatabase systems. Most of class time will be spent on the relational model and SQL as well as the Entity-Relationship model. You will be proficient in designing and programming database systems after you successfully finish this class. We will use a SQL database management system and a CASE (Computer Aided Software Engineering) tool for instruction and assignments. Prerequisite: MIS 2000, ECON 2100, or equivalent.
Learning Objectives
After completion of this course you should be able to:
- understand and identify the fundamental concepts of computer database design and management
- understand and use the concepts of entity-relationship diagram, relational mode, normalization, QBE, relational algebra, and SQL
- have experience using one of the database development software
- know how to design and implement a complete database system
- understand and identify the importance of database for the Internet-based electronic commerce
- learn basic knowledge of Geodatabases
- understand the continuing evolution of database technology
Required Materials
- Essentials of Database Management by Hoffer, Topi and Ramesh, ISBN: 9780133405682, Pearson, 2014
- Big Data, Big Analytics: Emerging Business Intelligence and Analytic Trends for Today's Businesses, by Minelli, Chambers, and Dhiraj, ISBN: 9781118147603, John Wiley & Sons, 2013
- Other class materials (e.g., assignments, class announcements, lecture notes, data files…) are available on our class web page.
Course Guidelines and Policies
Email Policy It is policy of CSUB that every single student MUST use CSUB issued email for all the class-related communications. That is, CSUB email is the ONLY official email. If you email me using your private email, I will not reply.
Microsoft Office 2016 is the official software for our university and you can download Microsoft Office 2016 through our university “Office365.” Unless it is specified by instructor, please do not use other software tools.
Youmust submit the assignment, the project, and the midterm exam through our course Blackboard submission link. Otherwise, it will not be accepted. If you’d like to avoid any type of problems, please submit using a PC in the school computer lab and also try to submit at least two days before the due date. When you submit the assignment/project/midterm exam, you MUST CLOSE the Microsoft office application (i.e., Word, PowerPoint, Excel and Access) COMPLETELY before you submit the file. Otherwise, you will receive ZERO POINT because ONLY title of your assignment/project/midterm exam file will be processed and accepted without including actual contents of your file. And if the assignment requires submit several files, you must submit all files together at once. That is, you must "UPLOAD" all the assignment files together at once.
Exam An exam will cover anything discussed in the class, readings in the textbook, or principles applied in the assignments. Students will be informed exact format of an exam prior to the exam. There is no make-up.
Attendance Policy Class attendance is required. The CSUB Catalog states: “The responsibility of the faculty is to establish specific attendance regulations and make-up policies that will maximize student learning, while avoiding penalties, where practical and possible, for university-related absences." The course is structured such that those who regularly attend class develop a better understanding of course material and subsequently perform better than those who do not. More than three absences will significantly negatively impact your final grade. If you are not attending class you cannot be participating in class. Note also that attendance for only part of a class is treated the same as an absence. There will be frequent announcements concerning course assignments. Therefore, you are responsible for any course changes I may announce throughout the quarter. Course changes are likely due to the discussion emphasis of this course that eliminates a rigid time schedule for reviewing course material. Class attendance will be checked without a notification.
Note: If you expect to be missing any significant class time (i.e., more than two consecutive classes) due to such events as marriage, honeymoon, vacation, work assignments, work travel, etc., you MUST notify me details of your absence by E-Mail prior to the absence. After you are retuned, you must submit proof document(s) (i.e., copy of flight ticket). If you fail to notify me, it will significantly negatively impact on your final grade.
Participation Class participation is an integral part of this course. Participation will be evaluated through my assessment of the quality of your class comments, and preparation for and participation in individual and group class exercises. Thorough preparation outside of class is very crucial to effective class participation. Participation will be used in determining where final grade cutoffs will be made. In addition, substantial extra credits will be awarded if you participate regularly.
Peer Group Evaluation Group evaluation is a part of the grading scheme. To prevent free riding in the group, the contribution of each member will be assessed. Each member is expected to submit a peer group evaluation at the end of the semester. Your evaluation is confidential. No one can review your peer group evaluation except the instructor. It is very important that you contribute your share in the group assignment (which includes attending the group meetings, contributing your ideas, writing the paper, analyzing the case, etc). Please remember that your final grade can be up or down graded significantly based on the evaluation result.
Civility and Respectful Conduct No interference will be allowed while the class is in session. Since we use a smart classroom, any computer related interference such as web surfing without permission from the instructor, and typing (email, paper…) will not be allowed. Additionally, talking to your classmate during the lecture, leaving the class without any prior notification, and sending text message will also not be allowed. A penalty for the interference is very severe. Up to 30% penalty from your total score will be applied depending on the level of interference.
Late Policy All Studentsmustbe on time to the class. If you are late more than 20 minutes, that will be counted as ABSENT. If you must late, you must notify me by email (at least 24hours before). If you violet this policy, at least 10% penalty from your total score will be applied.
Note: The CSUB catalog states: “Faculty are obligated to recognize and respect student diversity, ideas, perceptions, and opinions. At the same time, faculty have a fundamental responsibility to maintain the integrity of the learning environment. When confronted by unreasonable disruption in the classroom, faculty are expected to initiate actions to correct such conditions. Such actions may result in disciplinary action ranging from removal from the classroom to formal disciplinary sanctions, including probation, suspension, or expulsion.”
Late work Policy Each assignment will have a posted due date. You can still submit your work after the due date. However, 25% penalty will be applied for each day late. Obviously, if your work is more than four days late, you will receive zero point. There are no exceptions. Submission of a written excuse from the appropriate person such as a medical doctor is the only acceptable form of excuse. This will result a minimum extension to the due date to complete your work.
Office Hours Office hours will be held so that you may simply drop in if you need to discuss anything related to the course, your curriculum, your career, etc. I encourage you to take advantage of this time. If you have questions regarding assignments (other than about what is expected), I will expect you to demonstrate you have already put a reasonable effortinto solving the problems and/or analyzing the reading material and discussion questions. In this manner, we'll both benefit the most from the consultations. Please do not use office hours to try to make up for a missed class. If you have a valid
excuse for missing a one class, I will try to give you some direction in dealing with anything you might have missed; otherwise, please ask one of your classmates about what you have missed.
Computer Lab Policy The Lab policy by Dean’s office will be enforced all the time. Students are not allowed to stay in the MIS Lab without a faculty member present and students will not be allowed to loan the MIS lab pass card under no circumstances. There are no exceptions to this rule. Dean’s office established a formal security system. That system first involves the special security locks with the swipe card, second, an ironclad rule that no students (or other people except for faculty, IT or facilities personnel) are allowed in the Lab without a faculty member present.
Classroom Conduct. I expect that everyone in this class (Instructor included) will conduct him/herself in a professional manner. It is the policy of the California State University, Bakersfield to not discriminate on the basis of sex, sexual orientation, disability, race, color, religion, national or ethic origin in its educational programs. The faculty of the School of Business and Public administration strongly support this policy.
Academic HonestyStudents are expected to do all assigned work without unauthorized assistance. CSUB policy requires that instructors: (1) refer possible violations (with evidence) to the Office of Student Rights and Responsibilities for investigation and possible disciplinary action and (2) impose a grade penalty deemed appropriate, which includes possibly assigning a final grade of F. Campus policy on academic honesty can be found by doing a word search for "academic integrity" in the online CSUB Catalog.In this course, you are expected to do your own work on exams (including take-home components), following all guidelines for use of calculators, allowable reference materials, etc. You are allowed to work in groups on homework assignments to discuss strategies for solving problems and programming spreadsheet models, but you are not authorized to copy another students paper-and-pencil solutions or spreadsheet files.
Accommodations for Students with Disabilities The mission of the Services for Students with Disabilities Office (SSD) is to provide support services that will enable every student, regardless of disability, to have access to a university education. Students who think they may have a disability should contact the SSD Office in SA 140 to apply for services. SSD evaluates the application and recommends appropriate accommodations for the disabilities that it certifies. I follow all SSD recommendations.Do a word search for "Services for Students with Disabilities" in the online CSUB Catalog for a description of policies and support services and a listing of disabling conditions currently recognized by SSD.
Honor Code Students are expected to uphold the CSUB standard of conduct for students relating to academic dishonesty. Students assume full responsibility for the content and integrity of the academic work they submit. The guiding principle of academic integrity shall be that a student’s submitted work, examinations, and assignments must be that student’s own work.
Classroom Conduct. I expect that everyone in this class (Instructor included) will conduct him/herself in a professional manner. It is the policy of the California State University, Bakersfield to not discriminate on the basis of sex, sexual orientation, disability, race, color, religion, national or ethnic origin in its educational programs. The faculty of the School of Business and Public administration strongly support this policy.
Grading
* The grading percentages and scales are subject to change without notice*
Project / 100 points
Exam / 100points
Total / 200 points
Final grades will be determined by the following percentage scale:
95-100A84-87B74-77C60-65D
90-95A-80-84B- 70-74C-50-60D-
87-90B+ 77-80C+65-70D+0-50F
Course Activities
1) Assignment (individual or group)
Assignments are a crucial part of the class, and will take a substantial amount of time and effort. All assignments must be submitted and be of at least reasonable quality to earn a passing grade in the course. Plagiarism will result in a failing grade for the course. Just as you should not submit someone else's work, so to should you not make your assignment available to others to be copied or modified and later submitted by them. It is your obligation not to share your assignment with others. Each assignment is made available through its link to the class Web site. Usually, paper copies are not handed out. More detail instructions for each assignment will be announced verbally or posted on our class web site.
2) Project (individual or group)
A database is a model of a real world system. The contents of a database represent the state of what is being modeled. Changes in the database represent events occurring in the environment that change the state of what is being modeled. It is appropriate to structure a database to mirror what it is intended to model. Therefore, you are required to develop a real world database system as a group project. Specifically, entity-relationship (ER) diagram will be used as a main modeling tool. The entity-relationship diagram provides a convenient method for visualizing the interrelationships among entities in a given application. This tool has proven useful in making the transition from an information application description to a formal database schema. The entity-relationship model is used for describing the conceptual scheme of an enterprise without attention to the efficiency of the physical database design. The entity-relationship diagrams are later turned into a conceptual schema in one of the other models in which the database is actually implemented. More detail instructions of the project will be announced verbally or posted on our class web site.
Tentative Class Schedule
- The schedule is subject to change.
- More specific each week class schedule is available on our class web site.
Course Schedule
Wk / Class Materials / Assignment
Tuesday / Thursday
1 / Aug 29:Introduction to Class / Aug 31:Background of IS
2 / Sep 5:
DB Development:
- DB 1 LectureDB 2 Lecture
Online: Ch 1-The Database Environment and Development Process (Textbook Video Lecture) / Sep 7 (online):
Microsoft Access 2013 TutorialMust do!
Microsoft Access 2016 TutorialMust do!
DB files: Restaurant 1 (Order), Restaurant 2, and Restaurant3
Import Excel file PPT: import Excel file
Additional files: CSUB Logo, NewRest HTML, and Loan XML
DB examples: Composite PK, PK as FK, FineFood DB, Referential Integrity, and BillingAddress
Practice files: Excel (Course, Instructor, and Membership) and DB (Roadrunner database)
3 / Sep 12:DB Development:
- DB 3 Lecture
/ Sep 14:DB Development:
- DB 4 Lecture / DB Assignment (10 points):
- Due: Sep 20 (Wed 11:59pm)
- Do all the Access practices
- From the lectures (2, 3, and 4)
4 / Sep 19:DB Development:
- DB 4 Lecturecon't
- Group meeting / Sep 21: Access Database Exam
5 / Sep 26/28:Database Modeling
- Basics of Data Modeling Video and ERD using CASE tool
- Database Modeling Part I Lecture Note
- Business rules with model Requirements Discovery
Online: Ch 2-Modeling Data in Organization (Textbook Video Lecture) / Group Big Data Assignment 1
- Due: Sep 27 (Wed, 11:59pm)
- Chapter 1 of the Big Data textbook
6 / Oct 3/5:Database Modeling
- Database Modeling Part II Lecture Note
7 / Oct 10:/12 Database Modeling Practice & Group Assignment (based on progress!) / Group Big Data Assignment 2
- Due: Oct 11 (Wed, 11:59pm)
- Chapter 3 of the Big Data textbook
8 / Oct 17/19: Database Modeling Practice(con't)
Online:Ch 3-The Enhanced E-R Model (Textbook Video Lecture)
9 / Oct 24:Database Modeling Exam
Online: Ch 4-Logical Database Design and the Relational Model / Oct 26: Transformation
ERD to Relational DB Model / Group Big Data Assignment 3
- Due: Oct 25 (Wed, 11:59pm)
- Chapter 4 of the Big Data textbook
10 / Oct 31:Transformation
ERD to Realtional model Practice
Online: Ch 5-Physical Database Design and Performance (Textbook Video Lecture) / Nov 2: Reverse Engineering
Relational model to ERD: 1, 2, and 3
11 / Nov 7: Normalization
Normalization Lecture Note and Normalization Practice (Answer) / Nov 9: Normalization (con't)
Online: Ch 6-Introduction to SQL (Textbook Video Lecture) / Group Big Data Assignment 4
- Due: Nov 8 (Wed, 11:59pm)
- Chapter 5 of the Big Data textbook
12 / Nov 14/16: Structured Query Language
SQL Lecture Part 1, Restaurant DB, and SQL DB filefor the lecture
Online: Ch 7-Advanced SQL (Textbook Video Lecture)
13 / Nov 21 (online):
SQL Online: W3schools.com, SQLZOO, SQLCourse.com, and SQLCourse2.com
14 / Nov 28/30: Structured Query Language
SQL Lecture Part 2 and Answer for Each SQL Example
- Example of matching field SQL
Online: Ch 8-Database Application Development / Group Big Data Assignment 5
- Due: Nov 29 (Wed, 11:59pm)
- Chapter 6 of the Big Data textbook
15 / Dec 5:Structured Query Language (con't)
Online: Ch 9-Data Warehousing / Dec 7:
Catching up!
1