School ICT Self Study
Absolutely Free Learning Opportunity! No Need to Spend Money! Study at Your Own Pace! Everything You Need is Right Here
UNLOCK YOUR DIGITAL FUTURE!
Free ICT Learning for Sri Lanka
🚀 Welcome to School ICT

Your Gateway to Digital Excellence

🌍
|

Fundamentals of Database Concepts

436 viewsG10-09. Database
0

Question Title: Fundamentals of Database Concepts

  1. What is a database, and what are its main advantages?
  2. Name three key features of a relational database and explain one in detail.
  3. What are the key elements to consider when creating a manual database table?
  4. Why is it important to define data types when converting a manual database to an electronic one?
  5. What is the difference between a primary key and a foreign key in a relational database?
Ruwan Suraweera Changed status to publish
0

Answers and Descriptions:

basic database structure with tables fields and relationships

  1. Answer: A database is an organized collection of data, typically stored and accessed electronically. Its main advantages include efficient data management, reduced redundancy, improved accuracy, and enhanced security.
    Description: A database helps store and retrieve information systematically. For example, a school database can store student records without duplicating data (redundancy), ensuring accuracy and security for sensitive information.
  2. Answer: Three key features are absence of redundancy, consistency, and integrity. Consistency ensures that data remains uniform across the database (e.g., a student’s name is spelled the same everywhere).
    Description: These features make databases reliable. Consistency prevents confusion, like having “John Doe” in one record and “Jon Doe” in another, which could happen in manual systems.
  3. Answer: Key elements include field name (e.g., “Student ID”), unique field (e.g., a primary key), data types (e.g., text, number), and field size (e.g., maximum characters).
    Description: These elements ensure the table is structured. For instance, “Student ID” as a unique field prevents duplicate entries, while data types define what kind of data can be entered.
  4. Answer: Data types (e.g., text, number) ensure the electronic database processes and stores data correctly, matching the manual design.
    Description: For example, if “Age” is a number in the manual database, setting it as a number type in software allows calculations like averaging ages, which wouldn’t work if set as text.
  5. Answer: A primary key uniquely identifies each record in a table (e.g., “Student ID”), while a foreign key links to a primary key in another table (e.g., “Student ID” in a “Grades” table).
    Description: This relationship connects tables. For instance, a “Students” table has “Student ID” as the primary key, and a “Grades” table uses it as a foreign key to associate grades with students.
Ruwan Suraweera Changed status to publish
🔴 Lesson List
SIDE BUTTON ON
Sign In Register
×

👋 Welcome Back!

🚀
Ready to Learn?Pick up where you left off.
🔑
Forgot Password?Click the link below to reset.
📢
New FeaturesCheck out the new AI Voice tool.

Sign In

👤
🔒
or continue with
Google Facebook

Already have an account? Register Now

🖥️ View Desktop Version Switch to full website view.