cheat sheet_2 - Metadata-data that describes data DBMS...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Peter Dimas MSIS 110 Prof. Bharati Notes Sheet for Exam #2 Fields=columns, Records=rows Table/File -a group of similar rows or records Key -a column or group of columns that identifies a unique row in a table Foreign key -a key that exists in one table but is originated from a different one Relational databases -databases that carry their data in form of tables and represent relationships using foreign keys
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Metadata-data that describes data DBMS (Database Management System)-program used to create, process, and administer database SQL-Microsoft software, MySQL-OSS-open source, downloaded from internet for free Structured Query Language-international standard language for processing database Form-used to edit data. .. Report-shows data in structured way Query-type a keyword,...
View Full Document

This note was uploaded on 04/20/2008 for the course MSIS 110 taught by Professor Bharati during the Spring '08 term at University of Massachusetts Boston.

Ask a homework question - tutors are online