Database Management Syllabus



Database Management2 CreditsBU.330.770.XX[NOTE: Each section must have a separate syllabus.][Day & Time / ex: Monday, 6pm-9pm][Start & End Dates / ex: 8/20/18–10/15/18][Semester / ex: Fall 2018][Location / ex: Washington, DC]Instructor[Full Name]Contact Information[Email Address][Phone Number, ###- ###-#### (Optional)]Office Hours[Specify the day and time of the 2 hours that will be dedicated to office hours each week. For evening classes, faculty may wish to hold their office hours by phone or email. While faculty are permitted to state “and by appointment,” office hours should not be held exclusively by appointment.]Required Texts & Learning MaterialsCasteel, J., Oracle 12c: SQL,” 3rd edition, Cengage, 2015Suggested Books:Connolly, T. and C. Begg, “Database Systems: A Practical Approach to Design, Implementation, and Management,” 6th edition, Pearson, 2014Coronel, C. and S. Morris, “Database Systems: Design, Implementation, & Management,” 12th edition, Cengage, 2016Additional notes and readings will be posted via Blackboard > Course Document as needed.Software:We will use Oracle Database 12c Edition for Windows. No other components of Oracle Software will be used in the class.Course DescriptionThe emerging trend of organizations and business decision making is based on data-driven decision-making. In fact, database systems are central to most organizations’ information systems strategies. At any organizational level, users are expected to face frequent contact with and use of database systems. Therefore, skills in using such systems, which include understanding the capabilities and limitations of the systems, identifying whether to access data directly or through technical specialists and knowing how to retrieve and utilize the information effectively became essential in any industry vertical. Also, skills in designing new systems and related applications are distinct advantage and necessity today. The Relational Database Management System (RDBMS) is one type of database systems, which is widely used and is the primary focus of this course. Further, the course will provide students with an opportunity to apply the knowledge they learn from the lectures, homework assignments, SQL assignments, and a database implementation project.Course OverviewData are now recognized as a major organizational resource to be attained and managed like other assets such as land, labor and capital. The ability to structure, access, manage and leverage this valuable resource is becoming more and more critical to all organizations, large or small, public or private. Central to supporting this ability, and at the core of every information system, is the database. Developments in database technology have produced systems that are more powerful and easier to use, develop, and maintain. This course will address the theory, application, and management of relational database technology. The benefits supported by database systems is particularly the case for relational databases. Also, it is the database structure that is predominantly used for business applications, and thus, we focus on RDBMS in this course. The course will cover topics including an overview of the relational data model, understanding entities and relationships, designing logical data models and database design using the process of normalization. We will also learn relational algebra as the theory behind data queries and implement actual data queries using SQL to manage and retrieve data from an Oracle database.Learning ObjectivesAs a result of completing the activities of this course, students should be able to:Understand relational data model in terms of data structure, data integrity, and data manipulation.Understand and create conceptual database models utilizing entity-relationship.Design data structures that will limit redundancy and enforce data integrity while conforming to organizational requirements utilizing normalization methodology.Understand the theory behind the relational data model as it applies to interactions with current database management systems.Interpret a given data model to query the database and transform the data into information using SQL (Structured Query Language).Implement a data model in a current RDBMS.Create reports based on transactional data, including elements such as data groupings and summary values.To view the complete list of the Carey Business School’s general learning goals and objectives, visit the Carey website.AttendanceAttendance and class participation are part of each student’s course grade. Students are expected to attend all scheduled class sessions. Each class will include opportunities for teams to work together. Failure to attend class will result in an inability to achieve the objectives of the course. Excessive absence will result in loss of points for team participation. Regular attendance and active participation are required for students to successfully complete the course. If you have an event that prevents you from attending the class, please notify the instructor 48 hours prior to the class, and discuss with your group members in advance to arrange the group discussion and presentation accordingly. EvaluationStudents’ grades will be based on a combination of evaluation exercises consisting of two assignments, a case analysis, final project, final exam, and the student’s class participation. The breakdown of weights of each of the above is shown below.AssignmentLearning ObjectivesWeightAttendance and Participation1 - 710%Homework assignments/Quizzes1 – 720%SQL Assignments1 – 715%Project1 – 7 15%Final Exam1 – 7 40%Total100%Homework Assignments/Quizzes: The homework assignments require students to employ holistic critical thinking to design database models applying the concepts learned in the lectures. The focus is on understanding business requirements and designing data models to capture quality data. The range of topics covered in the assignments include conceptual and logical database modeling, normalization, and relational algebra. The relational algebra assignment is a foundation for learning the SQL. Quizzes may replace homework assignments` SQL Assignment: The SQL assignments are hands-on assignments that require students to create and execute various SQL statements and queries using Oracle Database 12c System. The submitted assignments are required to be well formatted and readable.Final project: Based on the logical model of a small database, the project consists of implementing the data structure, performing specific queries, data manipulation tasks, and querying system catalog to retrieve metadata. The project will integrate and apply the concepts you have learned in class. Detailed guidelines for the project assignment will be distributed and discussed in a later part of the semester. The project deliverables are due at the beginning of the last class meeting (see the course outline below). SQL assignments maybe incorporated into the final project.Exam: The exam will be comprehensive closed book, closed notes exam. The exam is to be completed by you individually without help of any other students. The date for the exam is specified in the class schedule. NOTICE ON ACADEMIC INTEGRITYThe use of unauthorized material, communication with fellow students during an examination, attempting to benefit from the work of another student, and similar behavior that defeats the intent of an examination or other class work is unacceptable to the University. It is often difficult to distinguish between a culpable act and inadvertent behavior resulting from the nervous tensions accompanying examinations. Where a clear violation has occurred, however, the instructor may disqualify the student's work as unacceptable and assign a failing grade on the paper. GradingThe grade of A is reserved for those who demonstrate extraordinarily excellent performance as determined by the instructor. The grade of A- is awarded only for excellent performance. The grades of B+, B, and B- are awarded for good performance. The grades of C+, C, and C- are awarded for adequate but substandard performance.?The grades of D+, D, and D- are not awarded at the graduate level (undergraduate only). The grade of F indicates the student’s failure to satisfactorily complete the course work.Please note that for Core and Foundation courses, a maximum of 25% of students may be awarded an A or A-; the grade point average of the class should not exceed 3.3. For Elective courses, a maximum of 35% of students may be awarded an A or A-; the grade point average of the class should not exceed 3.4. (For classes with 15 students or fewer, the class GPA cap is waived.)Tentative Course CalendarInstructors reserve the right to alter course content and/or adjust the pace to accommodate class progress. Students are responsible for keeping up with all adjustments to the course calendar.WeekContentReadingDue1Introduction to Database ConceptsDatabase EnvironmentChapter 1 & 2: Coronel et al.Chapter 1 CasteelChapter 2 Connolly and Begg2Relational ModelEntity Relationship ModelQuiz #1Chapter 4 Connolly and BeggChapter 12: Connolly and BeggChapter 3 & 4 Coronel et al.Quiz #13Basic SQLTablesDB CreationQuiz #2Chapter 2 CasteelChapter 3 CasteelQuiz #24Data ModelingConstraints & Data ManipulationQuiz #3Project OverviewChapter 4&5: CasteelQuiz #35Database Design (Logical and Conceptual)NormalizationDatabase ObjectsUser Creation and ManagementProject Review #1Chapter 16&17 Connolly and BeggChapter 6 Coronel et al.Chapter 14 Connolly and BeggChapter 6&7-Casteel6Managing DB tables-Data IntegritySingle and Multiple table queriesProject review #2Chapter 6-Connolly and BeggChapter 8-11 Casteel7Advanced QueriesSubqueries & MergeIntroduction to Regular Expression FunctionsBig DataProject DueChapter 12 & 13 CasteelProject Due8Final ExamComprehensive closed bookCarey Business School Policies and General InformationBlackboard SiteA Blackboard course site is set up for this course. Each student is expected to check the site throughout the semester as Blackboard will be the primary venue for outside classroom communications between the instructors and the students. Students can access the course site at . Support for Blackboard is available at 1-866-669-6138.Disability Support ServicesAll students with disabilities who require accommodations for this course should contact Disability Support Services at their earliest convenience to discuss their specific needs. If you have a documented disability, you must be registered with Disability Support Services (carey.disability@jhu.edu or 410-234-9243) to receive accommodations. For more information, please visit the Disability Support Services webpage.Academic Ethics PolicyCarey expects graduates to be innovative business leaders and exemplary global citizens. The Carey community believes that honesty, integrity, and community responsibility are qualities inherent in an exemplary citizen. The objective of the Academic Ethics Policy (AEP) is to create an environment of trust and respect among all members of the Carey academic community and hold Carey students accountable to the highest standards of academic integrity and excellence.It is the responsibility of every Carey student, faculty member, and staff member to familiarize themselves with the AEP and its procedures. Failure to become acquainted with this information will not excuse any student, faculty, or staff from the responsibility to abide by the AEP. Please contact the Student Services office if you have any questions. For the full policy, please visit the Academic Ethics Policy webpage.Student Conduct CodeThe fundamental purpose of the Johns Hopkins University’s regulation of student conduct is to promote and to protect the health, safety, welfare, property, and rights of all members of the University community as well as to promote the orderly operation of the University and to safeguard its property and facilities. As members of the University community, students accept certain responsibilities which support the educational mission and create an environment in which all students are afforded the same opportunity to succeed academically. Please contact the Student Services office if you have any questions. For the full policy, please visit the Student Conduct Code webpage.Student Success CenterThe Student Success Center offers free online and in-person one-on-one and group coaching in writing, presenting, and quantitative courses. For more information on these services and others, or to book an appointment, please visit the Student Success Center website.Other Important Policies and ServicesStudents are encouraged to consult the Student Handbook and Academic Catalog and Student Services and Resources for information regarding other policies and services.Copyright StatementUnless explicitly allowed by the instructor, course materials, class discussions, and examinations are created for and expected to be used by class participants only.?The recording and rebroadcasting of such material, by any means, is forbidden. Violations are subject to sanctions under the Academic Ethics Policy. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download