CSE+412+Database+Management

=CSE 412: Database Management=

This course is intended to give students an understanding of data modeling concepts and the relational data model for the storage and retrieval of information. The retrieval of information emphasizes the formal query languages and the industry-standard query language SQL.

SQL Relational Algebra ER Moduling
 * Introductory Module**


 * Introductory Video**


 * Knowledge Requirements**

=Overview=

// This will be a brief description of equipment, materials, and tools used in the module. Subject matter, module difficulty, and research facility clearances (if necessary) will also be covered in this section. The overview should provide enough information to allow inventioneers to determine if they have the skills necessary to complete the module. //

// *Rating system for each part of the module and comment section* //

Guided Tour
Difficulty Related Subjects Spaces Used


 * Required Labs:**

= = =Expectations=

// This will be a comprehensive list of all concepts, tools, and processes that should be learned through completion of the module. This section will be used for evaluating the academic and hands on skills that are required for mastery of the module. //


 * __Scientific Knowledge__**


 * __Tools/Machines Used__**

--Basic--
 * __Projects__**

--Intermediate--

--Expert--

= = =Background and Definitions=

// This section includes all the information that one must be familiar with before they start the module itself. This may include other modules, random science subjects, historical background, or anything else you can think of. Any terms or concepts or abbreviations used in the module that the readers may not be familiar with should be defined here. //
 * Green/Yellow/Red tabs to indicate difficulty level*

//Database Terminology//
//Scheme//
 * Database Scheme:**
 * Overall design of the database (DB)
 * Intention
 * Intentional Database


 * Database Instance:**
 * Collection of information stored in the DB at a particular instant in time
 * Extensional Database
 * Extension

//Languages//


 * Data Definition Language (DDL)**: used to specify the database scheme
 * Data Dictionary (catalog):** stores metadata, result of compiling DDL
 * Data Manipulation Language (DML)**: enables users to access or manipulate data
 * Query Language:** part of the DML that involves information retrieval
 * Query:** statement requesting the retrieval of information

//Users//


 * Definition Language (DDL)**: use

__Basics__
lklk

__History__
=Inspiring Ideas and Applications=

=Resources=

//Fundamentals of Database Systems//, R. Elmasri and S. B. Navathe, Addison Wesley, 4th Ed., 2004. //Understanding Relational Database Query Languages//, S. W. Dietrich, Prentice Hall, 2001. //Database Systems Concepts//, A. Silberschatz, H. Korth and S. Sudarshan, McGraw Hill. //An Introduction to Database Systems//, R. Ramakrishnan and J. Gehrke, McGraw Hill //An Introduction to Database Systems//, C. J. Date, Addison Wesley. //A First Course in Database Systems//, J. Ullman and J. Widom, Prentice Hall //Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL//, N. Shah, Prentice Hall

= = = = =Related Projects=

// Instructables, youtube videos, tutorials and anything else that is similar to the module at hand should be posted here. Related projects should provide additional methods for solving problems, give people ideas for new modules, and supplement module learning with fun, hands-on exercises. //

= = = = = = = = =News and Events=

// This section will exist to ensure that the module stays as updated and relevant as possible. Any news or scientific breakthroughs related to module subject matter can be found here. //

= = = = =Core Content=

// Here is where the the core of the module lies. It is the documentation and progress of the module itself. Many forms of media can be used such as excel data sheets, typed reports, pictures and videos of a project, transcripts from meetings, etc. This is work that the student has done, nothing that can be found somewhere else on the Internet or in a library. //

__*Link to wiki page for each students core project__ = = =Notes=

// Please feel free to ask any questions to further understand the concepts apart of this course. //

=Collaborators=

//Ramya Baratam//

=Knowledge Assessments=

Horse Racing ER Diagram
= =