70 likes | 133 Views
CSCI 1001. overview of. computer science. RELATIONAL DATA. spreadsheet. database. A database is a collection of tables ( relations ) Each table is a collection of records or tuples . Each record consists of attributes or fields .
E N D
CSCI 1001 overview of computer science RELATIONAL DATA
A database is a collection of tables (relations) Each table is a collection ofrecords or tuples. Each record consists of attributes or fields. An attributein a specific record is an item (element)
A Primary Keyis a set of attributes that uniquely identifies each record in a table. When a primary key is referenced in another table, it is a Foreign Key.
DATABASE PRINCIPALS DBA Procedures Queries User DBMS Database Replies