Database Management Systems

Course Description:

You will find that this class is a window to the world of Database Management Systems specifically focused to the structural formation of data, maintain data integrity, multitasking with concurrent access and recovery without occurring crashes, data structures, data models etc. and their working in which every organization.

What You Will Do

You will have following primary tasks during this course:

•Discuss Database management systems, databases and its applications

•Familiarize the students with a good formal foundation on the relational model.

•Outline the various systematic database design approaches.

•Describe the concepts of transactions and transaction processing and the issues, techniques related to concurrency and recovery manager.

•Explore the File organizations, indexing and hashing mechanisms.

You will be using an oracle SQL environment.

Main Expectations:

• Attend all classes. Your input and contribution is very important. If you are not in class, we cannot learn from you, and you cannot learn from other students.

• Follow ethical behavior during all class activities and understand the importance of ethical behavior for engineering practice. This includes but is not limited to why plagiarism is wrong, why cheating is wrong, and more importantly why striving for high quality practice based on your own work is critical to the success of an engineer.

• Come to each class prepared, having completed any reading assignments or homework assignments, and ready to discuss the readings and your assignment results.

• Be on-time for each class. If you are late, you not only disrupt others in the class when you enter, but you will miss out on important information.

• Participate fully in all classes and don't work on other class assignments or on computers during our class time.

• Turn in all assignments on time. Late assignments will not be accepted.

• Ask when you have a question. If you do not understand something that is being discussed, it is likely that others in the class do not understand as well. Asking questions is a very important part of the learning process.

• The work that you complete will be your best effort and of the highest quality. Learning to do work of high quality is important now and when you begin your career as a computer engineer.

• Work with others in the class on assignments. Working in teams is important in today’s engineering environment.

• Turn in will be your own work, not copied or unfairly extracted from other students or other sources.

• Be honest in your dealings with me and others in the class. High ethical standards are one of the cornerstones in engineering education and practice.

• Be engaged during class in whatever work that we are doing, and do not use computers or other electronic devices unless specifically instructed to do so. Please turn off cell phones before coming to class; texting or other electronic communications during class is strictly prohibited.

• Learn and have fun!