>>Welcome to the class CS 4513 Database Management Systems. So my name Le Gruenwald. I am a professor
in the school of computer science at the University of Oklahoma. I am the instructor of this course.
Databases play a key role in the information economy, culture and learning of the twenty-first
century. We see database use in all kinds of applications, from healthcare to education,
to business, to science. We see database as a component of many systems in tailored banking,
in e-commerce, in hospitals, in universities, in research centers like the NASA earth observing
system. So as the database continues to increase in diversity and volume the need to have a
database management system that can manage our databases is exploding. So an understanding
of database management system, how they work and how we can use it to handle our database
application is a very useful skill to have in the field of data science. So in general
this course covers the applications, the general principles, and the relevant theoretical formation
of database management systems, which is so and so called DBMS. The course introduces
the concept, the structures and the languages necessary for you to design and implement
a database application. A commercial DBMS could be used to carry out our database implementation.
The course also covers some computer ethic topics to ensure that the following outcomes
are met. The first outcome is an understanding of professional, ethical, legal, security,
and social issues and responsibilities. And the second outcome is an ability to analyze
the local and global impact of computing on individuals, organization, and society. So
in this course we will learn a number of important topics. We will learn what a DBMS is about,
why it is needed, and when we should use it to handle our database application and even
when we should not use it to handle our database applications. We will study the entity-relationship
model and use it to design databases. We will study the relational model and its languages
and use them to implement database applications. We will learn different file organizations
available on a DBMS and when each of those file organizations should be used to store
data in a database for specific application. We will study the concepts and theories of
functional dependencies and normalizations. And how we can use them to write a good database
design, a good… not only to deal with data redundancy but also very importantly to deals
query response time. So as query processing is essential for our database applications
we also want to know what techniques the DBMS use to process queries. We will study the
concept and the issues concerning data security and privacy. We will study what DBMS operation
we can use to control and access our databases. Who can have the authority to do that? and
how will authenticate that? And we will also study what impacts computer technology like
database technology will have on our privacy. We will also examine the transaction management
topic meaning that we will learn what is a database transaction, how it should define
and implement it for a particular database application. And how a DBMS manages our transactions.
Finally we will study the topic of evaluating and controlling the impacts of technology.
Which is a part of computer ethics. So in terms of creating the course consists of homework
assignments, a class project, and exams. The class project will require you to solve a
complete database problem. Going from the design stage to the implementation stage,
using a commercial DBMS. These projects requires knowledge from many of the topics covered
in the course. So I will recommend that you would want to put in plenty of thought and
effort into the class project to be sure to get started early. So please make sure to
read the syllabus carefully. It contains important information about your textbooks, grading,
and other policies. I hope you will enjoy the course.