(Grade X) Project Work

 



Date: 03/03/083

 

Case Study and Application-Based Questions


Submission date: 15/03/2083

 

Question 1: Rosebud School Database System

Case Study

Rosebud School wants to create a database system to manage student records, course details, and exam results. The database must store student ID, name, address, course ID, and marks obtained. The management also wants to ensure no two students have the same student ID, and each course has a unique course ID.

i) Design suitable table structures for this case.

ii) Identify primary keys and foreign keys.

iii) Mention why these keys are necessary in this situation.

 

Question 2: Employee and Department Database

Case Study

A company is managing its employee and department details in two different tables Employee and Department. The management wants to link the two tables so that every employee is assigned to a valid department.

i) Illustrate how you would create a relationship between these two tables using a FOREIGN KEY.

ii) Also, list two reasons why this relationship is important.

 

Instructions for Students

·       Use A4 size ruled.

·       Complete the work in neat handwritten form.

·       Use a pencil and ruler to draw all tables and diagrams neatly.

·       Draw relationship diagrams clearly wherever required.

·       Submit the project on the given submission date.

 

 

Question 1:

 (i) Design Suitable Table Structures

Create the following tables:

Table 1: Student

Field Name

Data Type

Description

Student_ID

Student_Name

Address

Table 2: Course

Field Name

Data Type

Description

Course_ID

Course_Name

Table 3: Exam_Result

Field Name

Data Type

Description

Result_ID

Student_ID

Course_ID

Marks

 

(ii) Identify Keys

Create a table like this:

Table Name

Primary Key

Foreign Key

Student

Course

Exam_Result

 

(iii) Explain the Importance of Keys

Write at least 3–4 sentences explaining:

What is a Primary Key?

What is a Foreign Key?

Why are these keys necessary in this database?

 

Question 2:

 (i) Create Table Structures

Table 1: Department

Field Name

Data Type

Description

Dept_ID

Dept_Name

Table 2: Employee

Field Name

Data Type

Description

Emp_ID

Emp_Name

Dept_ID

 

(ii) Draw the Relationship

Example One Department many Employee

 (Use ruler and pencil to draw neatly.)

 

(iii) Explain the Importance of the Relationship

Write any two reasons why the FOREIGN KEY relationship is important.

Example headings:

Data Integrity

Avoids Invalid Department Entries

(Explain each point in 2–3 sentences.)