BA371 Business Data Management — Course Syllabus
Prereqs: BA272 or equivalent; ACTG378 or BA370
4 Credits — 4 Hrs/Wk — Tue-Thu 10:00-11:50 AM || 12:00-1:50 PM || 4:00-5:50 PM — Lecture
René F. Reitsma, Ph.D.
College of Business
Reitsma classes and office hours
Lab-like exercises: self-guided exercises needed to successfully complete assignments. !!!NOTE: The exercises have been carefully designed to fit those assignments. Do yourself a BIG(!!) favor by carefully running them !!!
Class project: teams of five (5) people will each design and implement a small database project.
Exams & quizzes:
COB/BIS Community Credit: participation in COB/BIS-related community activities and events:
|Jan. 8||Welcome & course overview Database concepts 1 Database concepts 2||Coronel & Morris, Ch. 1, 2
|Jan. 10||Database concepts 2 Relational model||Class project||Coronel & Morris, Ch. 2, 3
|Jan. 15||Relational model
||Coronel & Morris, Ch. 3, 6
|Jan. 17||Two C# refreshers (in case you need them): C# — Excel communications||Class project|
|Jan. 22||Quiz 1 (in class)SQL:||Coronel & Morris, Ch. 7 pp. 246-270; 283-289
|Jan. 24||Programmatic database interaction:||Class project|
|Jan. 29||SQL data extraction
||Coronel & Morris, Ch. 7 pp. 271-282; 290-304
|Jan. 31||C#: Simple, Forms-based GUIs Assignment 1|
|Feb. 1||Class project: delivery 1 due|
|Feb. 5||Transaction control (commit/rollback) Triggers & stored procedures||Class project||Coronel & Morris, Ch. 8 pp. 392-406; ch. 10
|Feb. 8||BIS@OSU Meet the Firms
10:00 AM — 2:00 PM
@ Austin Hall
|Assignment 1 due|
|Feb. 12||Midterm (in class) NoSQL: XML & JSON data||Reitsma & Krueger, Ch. 3 (up to Enough Theory...); Ch. 4 (up to TeachEngineering (TE 2.0)...
|Feb. 13||Portland SIM field trip (no BIS classes)
COB vans leave COB at 6:30 AM from the Jefferson Street (South) entrance of Austin Hall.
|Feb. 14||C# — XML & JSON lab Assignment 2||Reitsma & Krueger, Ch. 3 (starting with Enough Theory...)
|Feb. 15||Reitsma & Krueger, Ch. 3 (starting with Enough Theory...)
|Feb. 19||NoSQL databases
NoSQL case study: TeachEngineering 2.0
||Coronel & Morris (pp. 662-668)
Cotrupe, J. (2018) Time to Say Yes to NoSQL. Frost & Sullivan Statecast (available on Canvas).
Reitsma & Krueger, Ch. 5 (up to Some Practice with two JSON Document Stores...
|Feb. 21||Guest lecture: Joe Markgraf (SAP / BIS—2010); HANA: SAP's in-memory database
||Reitsma & Krueger, Ch. 5 (starting with Some Practice with two JSON Document Stores...); Ch. 4
|Feb. 22||Assignment 2 due
|Feb. 26||Quiz 2 (in class)
Database administration and business data management
||Coronel & Morris, Ch. 16 Veritas (2018) Data Management, pp.1-10 (available on Canvas—>Files)|
|Feb. 28||Class project|
|Mar. 5||Class project|
|Mar. 7||Class project|
||Class project: presentations|
||Class project: presentations|
||Class project: delivery 2 due Class project: peer evaluations due|
|Class project: Delivery 1 (Ch. 1, 2) — team grade*||10 points|
|Class project: Prototype demonstration — team grade*||10 points|
|Class project: Delivery 2 (Ch 1, 2, 3) — team grade*||10 points|
|Class project: Peer evaluation grade — individual grade Note: To receive peer evaluation credit, you must yourself turn in the evaluation of your peers.||5 points|
|Midterm exam — individual grade||20 points|
|Quizzes — individual grade||15 points|
|Assignments — individual grade Note: You will only receive credit for your coding work if you turn in good, serious and on-time code reviews. You must score a minimum of 60% on both assignments in order to receive any credit for that assignment.||25 points|
|COB/BIS community events Community event participation must occur within the current term. Different event types may not be combined. Fractional/partial credit will be given.||5 points|
|* 'Team grade' means that all members of the team receive the same grade. However, as an individual, you will only receive that team grade if you have appropriately and sufficiently contributed to the team's accomplishments. Simply put: if you do not contribute, you will not receive team credit. Also, your instructor may ask you to redo a class project report. Such redo's, however, suffer a 15% grade penalty.|
The following number-to-letter grade scale will be used for calculating the final letter grade (all grades normalized to 100):
F < 55.00
55.00 <= C- < 60.00
60.00 <= C < 65.00
65.00 <= C+ < 70.00
70.00 <= B- < 75.00
75.00 <= B < 80.00
80.00 <= B+ < 85.00
85.00 <= A- < 90.00
A >= 90.00
Accommodations for students with disabilities are determined and approved by Disability Access Services (DAS). If you, as a student, believe you are eligible for accommodations but have not obtained approval please contact DAS immediately at 541-737-4098 or at http://ds.oregonstate.edu. DAS notifies students and faculty members of approved academic accommodations and coordinates implementation of those accommodations. While not required, students and faculty members are encouraged to discuss details of the implementation of individual accommodations.
Instructor Commitment to Equity, Diversity and Inclusion
Your instructor (I) believe strongly that the diverse backgrounds and perspectives of students and the larger university community are a strength and a benefit, both in class and in society. I strive to reflect and enact OSU's commitment to embracing equity, diversity and inclusion in all aspects of my teaching, research and service at OSU. You should be aware that some of the materials we cover may be difficult to read and/or discuss, or may represent opinions that you find offensive or objectionable. As we examine this material, it is essential that we are respectful to each other both online and face-to-face. Your suggestions for improving this course are encouraged and appreciated, and I hope you will contact me if you have any questions or concerns. Each of us has a responsibility to work to create an environment free of harassment and discrimination. Please take a moment to read the University Policy on discrimination and harassment. If you feel you have experienced sexual misconduct, discrimination, harassment, bullying, or retaliation, please see the Office of Equal Opportunity and Access for information about reporting.