1. What are the main components of a database? The two main components are the data engine and the data file. Also tables ,records and fields.
2. What is the difference between a record and a field? A field is a column in a table. Record is a row of data added to this table.
3. What are primary keys? What are they used for? Primary keys are a key in a relational database that is unique for each record. It is used to uniquely identify each row in a table
4. Draw up a table which could be used for data about students who borrow books from a library. Identify and label a record, a field and the primary key.
5. Why would we not put the students’ data in the same file as the books?
6. If data is repeated unnecessarily in a table, it is called redundant. Why do you think that databases should be designed to minimise data redundancy? if you are sorting a table that has alot of redundant data it takes far too long to organise data.
Leave a Comment
No comments yet.
Comments RSS TrackBack Identifier URI
