database management - 3 Record A record is a row into a...

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

View Full Document Right Arrow Icon
1. Discuss each of the following terms: 1. Data - Data is facts that we collect and can be stored in a database. 2. Field - In a database table we typically have several fields. These fields identify the data inserted into their column. Fields typically have certain properties like varchar, char or int. A field having these properties only allows us to insert that type of data. Fields are also given a set limit of characters they can hold.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3. Record - A record is a row into a table. Records can then be updated deleted and new ones inserted. 4. File – Files are needed to store the information about the databases, their tables and the tables fields, lastly files then store the data. What is data redundancy and, and which are characteristics that can lead to it? Data redundancy is duplicate records....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online