CSE 3241
Transcript Abbreviation:
Intr Database Sys
Course Description:
Database systems use, logical design, entity-relationship model, normalization, query languages and SQL, relational algebra and calculus, object relational databases, XML, active databases; database design project.
Course Levels:
Undergraduate (1000-5000 level)
Designation:
Elective
General Education Course:
(N/A)
Cross-Listings:
(N/A)
Credit Hours (Minimum if “Range”selected):
3.00
Max Credit Hours:
(N/A)
Select if Repeatable:
Off
Maximum Repeatable Credits:
(N/A)
Total Completions Allowed:
(N/A)
Allow Multiple Enrollments in Term:
No
Course Length:
14 weeks (autumn or spring)
12 weeks (summer only)
Off Campus:
Never
Campus Location:
Columbus
Instruction Modes:
In Person (75-100% campus; 0-24% online)
Distance Learning (100% online)
Prerequisites and Co-requisites:
Prereq: 2123 or 2231; and 2321, or 2111 and Math 2366; and enrollment in CSE, CIS, ISE, Data Analytics, ECE, Engr Physics, or Business Info Sys majors, or CIS minor.
Electronically Enforced:
No
Exclusions:
Not open to students with credit for 5241.
Course Goals / Objectives:
Master using relational databases
Master writing queries in relational data languages including SQL and relational algebra
Master using mechanisms for data independence, including data models, languages and views
Be competent with logical database design
Be competent with conceptual database design
Be familiar with object relational database technology
Be exposed to XML and active databases
Check if concurrence sought:
No
Contact Hours:
| Topic | LEC | REC out-of-class | REC in-class | Weekly LAB out-of-class | Weekly LAB in-class |
|---|---|---|---|---|---|
| Entity-Relationship (ER) Model | 4.0 | 0.0 | 0 | 0.0 | 0 |
| The Structure of the Relational Data Model | 2.0 | 0.0 | 0 | 0.0 | 0 |
| Relational Algebra and Relational Calculus | 6.0 | 0.0 | 0 | 0.0 | 0 |
| Functional Dependencies and Normalization | 8.0 | 0.0 | 0 | 0.0 | 0 |
| ER-to-Relational Data Model | 1.0 | 0.0 | 0 | 0.0 | 0 |
| SQL | 6.0 | 0.0 | 0 | 0.0 | 0 |
| Graphical User Interfaces | 2.0 | 0.0 | 0 | 0.0 | 0 |
| Embedded SQL | 2.0 | 0.0 | 0 | 0.0 | 0 |
| Object Relational Databases | 4.0 | 0.0 | 0 | 0.0 | 0 |
| XML | 3.0 | 0.0 | 0 | 0.0 | 0 |
| Active Databases | 2.0 | 0.0 | 0 | 0.0 | 0 |
| Total | 40 | 0 | 0 | 0 | 0 |
Grading Plan:
Letter Grade
Course Components:
Lecture
Grade Roster Component:
Lecture
Credit by Exam (EM):
No
Grades Breakdown:
| Aspect | Percent |
|---|---|
| Homework | 30% |
| Project | 20% |
| Midterm Exam | 20% |
| Final Exam | 30% |
Representative Textbooks and Other Course Materials:
| Title | Author | Year |
|---|---|---|
| Fundamentals of Database Systems, Addison-Wesley, 5th edition | Ramez Elmasri and Shamkant Navathe |
ABET-CAC Criterion 3 Outcomes:
| Significant contribution (7+ hours) | 1 | Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify solutions. |
| Substantial contribution (3-6 hours) | 2 | Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline. |
| Some contribution (1-2 hours) | 3 | Communicate effectively in a variety of professional contexts. |
| Some contribution (1-2 hours) | 4 | Recognize professional responsibilities and make informed judgments in computing practice based on legal and ethical principles |
| Significant contribution (7+ hours) | 5 | Function effectively as a member or leader of a team engaged in activities appropriate to the program’s discipline |
| Some contribution (1-2 hours) | 6 | Apply computer science theory and software development fundamentals to produce computing-based solutions. |
ABET-ETAC Criterion 3 Outcomes:
(N/A)
ABET-EAC Criterion 3 Outcomes:
| Significant contribution (7+ hours) | 1 | an ability to identify, formulate, and solve complex engineering problems by applying principles of engineering, science, and mathematics |
| Substantial contribution (3-6 hours) | 2 | an ability to apply engineering design to produce solutions that meet specified needs with consideration of public health, safety, and welfare, as well as global, cultural, social, environmental, and economic factors |
| Some contribution (1-2 hours) | 3 | an ability to communicate effectively with a range of audiences - pre-2019 EAC SLO (g) |
| Some contribution (1-2 hours) | 4 | an ability to recognize ethical and professional responsibilities in engineering situations and make informed judgments, which must consider the impact of engineering solutions in global, economic, environmental, and societal contexts |
| Significant contribution (7+ hours) | 5 | an ability to function effectively on a team whose members together provide leadership, create a collaborative and inclusive environment, establish goals, plan tasks, and meet objectives |
| Some contribution (1-2 hours) | 6 | an ability to develop and conduct appropriate experimentation, analyze and interpret data, and use engineering judgment to draw conclusions |
| Some contribution (1-2 hours) | 7 | an ability to acquire and apply new knowledge as needed, using appropriate learning strategies |
Embedded Literacies Info: