The purpose of this assignment is to help you learn more about databases in real life.
Databases are important in businesses and organizations because they provide a highly efficient method for handling data. Some of the data that are easily managed include: employee records, student information, payroll, accounting, project management and inventory, etc. A database management system stores, organizes and manages a large amount of information.
- You are requested to submit one example of application where databases are used and discuss one relation from this database. You need to illustrate attributes and keys.
During students’ admission, a school database can contain students and contact information tables. The type of relationship in this database will be a one-one relationship, meaning that one record in the students’ table will be associated with one record in the contact information table. The students’ table can have a Student ID, LastName, and FirstName. In this table, every student will only have one Student ID, and every Student ID will be given to only one student. The contact information table can have a Student ID, Phone, and City. Again, the Student ID will be unique for every student, and it will be similar to the value of Student ID in the students’ table.