Computer Literacy
Chapter 1A Introduction of Database
Name: ____________________ Class: ________ ( )
Spreadsheet:
• Spreadsheet is used for organizing and analyzing data in a tabular format.
• It is primarily used for calculations, creating charts, and performing mathematical operations.
• Data is stored in rows and columns in a spreadsheet
Database:
• Database is used for storing and
managing large amounts of structured
data.
• Information in a database is organized
into tables with different fields or
attributes.
• Databases are designed for efficient
data storage, retrieval, and
manipulation.
1A Introduction of Database 1
Example of a database:
Below is a sample student report card.
1A Introduction of Database 2
All student reports are generated by data from different tables in the school database system.
1. One of the tables in the student database is called "studentinfo". Please list some fields in the report
that come from this table. What is their data type?
Field Data Type
StudentName Text
2. For each subject, we have an individual table. Can you please suggest some fields that should be
included in each subject table? Additionally, could you specify their respective data types?
Field Data Type
3. Are we required to input the average mark of each student? If so, how can we obtain this
information?
_________________________________________________________________________
_________________________________________________________________________
4. Suggest other tables in the database and their details.
Table name Fields Data Type
1A Introduction of Database 3
Which one should be used? Spreadsheet or database?
Spreadsheet Database
1 When tracking and analyzing workout progress or personal goals.
2 When creating a budget for personal expenses and tracking monthly
expenses.
3 When organizing and analyzing inventory data for a warehouse with
thousands of products.
4 When organizing and analyzing data for a business with a limited
number of products or services.
5 When managing customer information for a large e-commerce website
with millions of customers.
6 When tracking student records, courses, and grades for a university
with multiple departments.
7 When creating a simple sales report for one retail store.
8 When storing and retrieving financial transactions for a multinational
company.
1A Introduction of Database 4