Monday 1:30 am – 4:00 pm
Modern Database Management, 11th edition Author:
Jeffrey A. Hoffer, V. Ramesh, Heikki Topi
FACULTY CONTACT INFORMATION: firstname.lastname@example.org
Are held in classroom an half hour before and after class.
This course covers the concepts of databases and data base usage, database system concepts and architecture, data modeling using the entity-relationship model, record storage and primary file organizations, index structures for files, relational model concepts, SQL-the relational database standard, relational database design , examples of relational database management systems: Oracle, database design, database recovery techniques, database security and authorization, data warehousing and data mining. This course provides an understanding of the issues in man aging database systems as an essential organizational Resource. Students learn the enterprise data architecture Components, data storage configurations, and information retrieval methods. Focus will expand from the relational model to the multidimensional l model, and include object-relational techniques, data security and data recovery.
MAJOR INSTRUCTIONAL GOALS
Understand concepts covered in class that relate to Data Base Management Systems (DBMS) in a contemporary business environment. Learning Outcomes: The student will be able to:
Examine and research topics of current interest specific to data management concepts A-2
Produce data reports
Distinguish between data models
Design a working database
Gain an appreciation of the technologies involved in data-based systems and applications. Learning Outcomes: The student will be able to:
Identify through use, data modeling concepts
Distinguish between database technologies
Develop quires and reports
Identify hardware required to support/operate a DBMS environment GOAL C:
Become familiar with data warehousing and data mining concepts Learning Outcomes: The student will be able to:
Identify practical applications of data warehousing and data mining C-2
Identify advantages and disadvantages of data warehousing and data mining systems
Understand the value of Database Recovery and Database Back-up Planning Learning Outcomes: The student will be able to:
Describe from a business perspective, the importance of Data base Recovery D-2
Identify strategies and methodologies for backing-up data D-3
Demonstrate knowledge of requirements for the development of a Database Back-up Plan
Student must complete the assigned “on-line writing evaluation”. Tutoring is free at the Student Success Center, DAC 219. Take the problems you have difficulty with you, to the center so they know where to focus your assistance. Go to blackboard and log into the course. Click on “Online Tutoring” from the menu.
Assignments are due at the beginning of class on the specified due dates of that assignment. 10% will be immediately deducted if they are not presented to the instructor at the beginning of class. An additional 10% will be deducted each day at class time (including weekends) until the assignment is submitted. METHODOLOGY:
A. Teaching Methods: Cell phones will not be tolerated during class. Cell phones must be turned off during class (not on vibrate). If you must leave your phone on, please discuss this with the instructor, who will provide instructions for you. Do not text-message during class. This can be very distracting to other students. STUDENTS WHO ARE USING CELL PHONES DURING CLASS WILL BE ASKED TO LEAVE. While I am not fond of having laptops in class, I do realize that some students may want to use laptops for...
Please join StudyMode to read the full document