1. Advantages of database over Advantages of spread sheets;
One of the advantages of database is that it reduced data redundancy this is because in databases, there is an identifier. The identifier is the primary key, where when it is entered, all other details, which saved under the primary key, will be revealed. Therefore, there’ll be less repetition of data. Next, databases improved data integrity, which it will guaranteed the data proven to be correct. Linked to the primary key function, the data will be correct as there’s no redundancy. Databases also improved data security where the data in databases will be protected and only authorised personnel can have access into it. Databases are obviously reducing errors and increased the consistency of the data or information channelled. On the other hand, spread sheets only perform a better calculation as it displays the formulas and the stages of calculations. It is user-friendly that user could use and understand how to use spread sheet in calculations. Hence, it will increase the productivity of users or employees when performing tasks as user does not have to understand difficult terms or operations. Spread sheet also exhibits a clear layout of data that it only involves one theme. In general, databases are more enhanced than spread sheet as it performs more functions, which are more practical.
3. a) Based on the figure 5.20, there can be many advisors for one student. This is called many to one relationship and the maximum cardinality is only one student for many advisors. b) One to one relationship means that one advisor only can accommodate one student. c) 5:1 relationship means that one student only can consult five advisors and the maximum cardinality is five. d) 1:5 relationship means one advisor only caters five students and the maximum cardinality is five. 4. Two entities in the data entry form in Figure 5.28 are employee...
Please join StudyMode to read the full document