UT Dallas CS 6360 - lab-manual (215 pages)

Previewing pages 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215 of 215 page document View the full content.
View Full Document

lab-manual



Previewing pages 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215 of actual document.

View the full content.
View Full Document
View Full Document

lab-manual

176 views


Pages:
215
School:
University of Texas at Dallas
Course:
Cs 6360 - Database Design
Database Design Documents

Unformatted text preview:

Fundamentals of Database Systems Laboratory Manual1 Rajshekhar Sunderraman Georgia State University August 2010 1 To accompany Elmasri and Navathe Fundamentals of Database Systems 6th Edition Addison Wesley 2010 2 Preface This laboratory manual accompanies the popular database textbook Elmasri and Navathe Fundamentals of Database Systems 6th Edition Addison Wesley 2010 It provides supplemental materials to enhance the practical coverage of concepts in an introductory database systems course The material presented in this laboratory manual complement many of the chapters of the Elmasri Navathe text typically covered in most introductory database systems courses Chapter Mappings The laboratory manual consists of 8 chapters and the following table shows the mapping to the chapters in the Elmasri Navathe textbook Laboratory Manual Chapter Elmasri Navathe 6th Edition Chapter s Chapter 1 Chapters 7 8 and 9 Chapter 2 Chapters 3 6 and 26 Chapter 3 Chapters 4 5 and 13 Chapter 4 Chapters 4 5 and 14 Chapter 5 Chapters 15 and 16 Chapter 6 Chapter 11 Chapter 7 Chapter 12 Chapter 8 Chapters 13 and 14 Chapter 1 presents ERWin a popular data modeling software that allows database designers to represent Entity Relationship diagrams and automatically generate relational SQL code to create the database in one of several commercial relational database management systems such as Oracle or Microsoft SQLServer The material presented in this chapter is tutorial in nature and covers the COMPANY database design of the Elmasri Navathe text in detail Chapter 2 presents three interpreters that can be used to execute queries in Relational Algebra Domain Relational Calculus and Datalog These interpreters are part of a Java package that includes a rudimentary database engine capable of storing relations and able to perform basic relational algebraic operations on these relations It is hoped that these interpreters will allow the student to get a better understanding of abstract query languages



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view lab-manual and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view lab-manual and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?