帮写CS 411: Database Systems代写Java编程

CS 411: Database Systems

Course Description

As the first introductory course for databases, this course studies the fundamentals of using and implementing relational and non-relational database management systems. First, from the user perspective (i.e., how to use a database system), the course will discuss conceptual data modeling, physical data modeling, computing on data, designing schemas, querying databases, and manipulating databases. We will study both the relational and “NoSQL” databases such as document and graph databases. Further, from the system perspective (i.e., how to design and implement a database system), the course will study data representation, data accessing and indexing, query processing and optimization, and transaction processing.

Course Prerequisite

.     Background: CS225 Data Structures.

.     Programming: You should be comfortable in programming and can quickly learn a new language if needed. You should be able to use major programming languages such as Python and Java.

Course Goals

By the end of the course, you will be able to:

.     Use a database system for storing, managing, and querying data.

.     Design and create a data-driven application using a database system.

.     Identify the differences between relational and non-relational (NoSQL) systems and their target usage and application settings.

.     Describe the internal architecture and key components of a database system.

.     Design and implement data indexing, query processing and optimization, and transaction processing algorithms.

Textbook

Database Systems: The Complete Book, 2nd edition, by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer D. Widom.