College of Business & Technology
Department of Management & Marketing
Spring 2024

1. Course Information:

Prefix:	IS (Information Systems) HCA (Health Care Administration)
Number:	IS 4293 (Business Database Management Systems) IS 5313 (Structured Data Design and Querying) HCA 5423 (Health Services Technology and Application)
CRNs:	(Course Reference Number) 31233 & 32602 - IS 4293 (Business Database Management Systems) 31236 - IS 5313 (Structured Data Design and Querying) 31125 - HCA 5423 (Health Services Technology and Application)
Credits:	3 hours undergraduate/graduate credit
Title:	Business Database Management Systems Structured Data Design and Querying Health Services Technology and Application

2. Instructor Name:

	Name:		Dr. Bill Rosener
	E-mail:		rosener@nsuok.edu
	Phone:		(918) 456-4482 (cell) (918) 444-2923 (office)
	Office Location:		221-D Business and Technology
	Office Hours:		Office Hours
	Zoom:		https://nsuok.zoom.us/j/9184564482
	Homepage:		https://www.billrosener.com

3. Course Delivery Method:

Online

4. Workload / Credit Hour Statement:

You should plan on a minimum average of 9 hours per week of “time on task.” Time on task includes any time that you spend interacting with course materials and participating in learning activities, including but not limited to readings, projects, assignments, videos, student-student or student-professor interaction, and exams.

5. Class Days / Meeting Times:

Asynchronous learning - you can complete the work on your own schedule.

6. Course Prerequisites and/or Co-requisites:

Computer proficiency.

7. Catalog Description:

IS 4293: Students examine database management systems and principles including: logic design, normalization, restraint, constraints, SQL, and database administration. Students identify and describe data-driven web sites with special attention to interactive databases and e-commerce.

IS 5313: Students will learn how to administer a structured database and extract data for use in analytics. Topics include database management systems and principles, logic design, normalization, restraint, constraints, and SQL. Students are introduced to data-driven web sites with special attention to interactive databases and e-commerce.

HCA 5423: Students gain a foundational and practical understanding of the collection, storage and use of health services information. Technology is utilized to maximize the use of information and systems for decision-making in the delivery of efficient, high quality health care. Specific emphasis is placed on the practical application of technology from the managerial and clinical perspectives.

8. Course Purpose / Goals:

• Business Database Management Systems is required for all BBA IS Majors and BS Cyber Security Majors. It is also a popular course for IS Minors and Health Care Administration.

9. Student Learning Outcomes:

• Develop a working vocabulary of database and information systems terminology.
• Develop an understanding of normalization.
• Demonstrate an understanding of data structures and types and understand data and database modeling and development.
• Construct SQL statements that Select, Insert, Update, or Delete records, fields, tables, or databases.
• Write and interpret written descriptions of database requirements and specifications.
• Employ electronic tools to aid in database development and administration.
• Strengthen their ability to comprehend and synthesize information; and improve their writing, oral, and critical thinking skills.

10. Instructional Methods / Strategies:

The expected course outcomes will be realized through a variety of instructional strategies including: training videos, lecture notes, textbook, and other related readings and activities. Additional course materials will be provided as handouts, assigned URLs, or placed on the Web.

11. Learning Outcome Assessment Methods:

Points   Task #1* 10   Discussion Board 50   Assignments** 560   Final Project 100     Total 720   *Obtain space, complete syllabus agreement **Seven Assignments (80 points each)

The point assignments shown above are approximate and the actual point assignments at the end of the semester may vary from the breakdown shown above. Grades are awarded on a total earned basis as a percentage of possible points for the semester.

12. Instructional Materials:

Database Concepts
10th Edition
David Kroenke, David Auer, Scott Vandenberg, and Robert Yoder.
© 2024
Pearson
ISBN-13: 978-0-13-791678-8.

 

Students might consider purchasing a USB flash drive (e.g., Jump Drive). These portable storage devices can be very helpful in storing, carrying, and transferring information between home and school. All students are expected to have their accounts on the NSU networks by the end of the first week of the semester.

13. Grading Policy / Scale:

Letter grades are assigned at the end of the semester based on the following scale where X denotes your average.

	Your Average				Grade
		X	>= 90%		A
	90% >	X	>= 80%		B
	80% >	X	>= 70%		C
	70% >	X	>= 60%		D
	60% >	X			F

14. Class and Instructor Policies:

All work is to be prepared and submitted according to the directions given. Extended illness, injury, or emergency situations will be handled on a case-by-case basis at the professor's discretion.

15. Academic Policies / Required Information:

Please go to the following weblink: Academic Affairs Syllabus Information link for required information pertaining to:

• Academic Misconduct
• Americans with Disabilities Act Compliance
• Behavior Intervention Team
• Inclement Weather/Disaster Policy
• Release of Confidential Information
• Student Handbook
• Teach Act
• Textbook Information
• Title IX

The College of Business and Technology (CBT) Standards of Professional Behavior are designed and established to foster a safe, secure, and respectful learning environment conducive to the preparation of students for success in an increasingly challenging, diverse, and global society. Students enrolled in classes offered by the CBT are expected to behave according to the CBT Standards of Professional Behavior.

16. Student Support:

Students enrolled in postsecondary education are required to self-identify if they would like to request services on the basis of disability. Student Disability Services provides or arranges reasonable accommodations and services to qualifying students. You can learn more here: Student Disability Services

Students who may need assistance accessing sufficient food to eat every day, lack a safe and stable place to live, or who may be experiencing mental health challenges impacting their performance in the course are urged to contact Student Affairs or HawkReach Counseling Services for support. Additional resources are available through the Food Pantry (NSU-BA) and Rowdy's Resource Room (NSU-Tahlequah). An online report may also be submitted through the Report Concern link.

17. Course Concerns or Complaints

Students who wish to express a concern about a course or academic issue are encouraged to follow this process. Students who want to file a course grade appeal should consult the next section.

• First, conference with the faculty member. Most concerns can be handled through dialogue with the course instructor.
• Second, if the instructor is unable to resolve the issue, the student may talk with the department chair. If the student does not know who the department chair is, s/he can contact the registrar with the course prefix and number, and that office can provide the information.
• Third, if the department chair is unable to resolve the issue, then the student is welcome to contact the assistant or associate dean. If the student does not know who the assistant / associate dean is, they can ask the department chair or contact the registrar.
• Fourth, if the assistant / associate dean is unable to resolve the issue, the student may contact the college dean.

It is important that the student initiate action (not parents, partners, or other relatives) and begin at the faculty or department chair level as most issues can be resolved there.

18. Grade Appeal

A student may petition a course grade change by using the Grade Appeals Timeline and Policy if satisfactory resolution cannot be achieved after informal grade review conferences with the instructor, department chair, and/or Dean’s office. The Grade Appeals Process must be formally initiated with a written appeal to the Dean within four months following awarding of the original course grade. Please contact the dean of the college in which the grade was given for a copy of the grade appeals process and the conditions which allow for the appeal of a course grade.

19. Class Calendar with Assignment Due Dates:

See "Steps to completing this course" for assignment due dates.