IS ch - In a relational database the three basic operations...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
In a relational database the three basic operations used to develop useful sets of data are Select project and join The select operation Creates a subset consisting of all records in the file that meets stated criteria The join operation Combines relational tables to provide the user with more information than is otherwise available The project operation Creates a subset consisting of columns in a table The data dictionary serves as an important data management tool by Creating an inventory of data definitions contained in the database. An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation ownership authorization and security is the Data definition diagram The specialized language programmers use to add and change data in the database is called Structured Query Language The most prominent data manipulation language today is Crystal reports DBMS typically include report generating tools in order to
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/04/2012 for the course IS 3003 taught by Professor Rao during the Spring '08 term at The University of Texas at San Antonio- San Antonio.

Page1 / 3

IS ch - In a relational database the three basic operations...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online