Project 1: Technological Solution for XYZ Import and Export Company
Company Overview
XYZ Import and Export Company is engaged in exporting various products, including mining
products, livestock, coffee, and more. The company also imports machinery, food, beverages,
and other goods. The organization is structured into the following divisions:
Stock Division: Responsible for managing stock, including item registration and data
operations.
Finance Division: Manages all financial activities of the company.
Customer Relations Division: Handles frequent interactions between the company and
customers.
Human Resources Division: Oversees all HR-related activities within the company.
Tasks to Perform
Task 1: Prepare a Bill of Quantity
List the required materials and professionals.
Include the associated costs in an appropriate format.
Task 2: Prepare an Activity Plan
List all activities required for the given scenario.
Assign responsible professionals for each task.
Format the information appropriately.
Task 3: Develop a Time Schedule
Prepare a time schedule in weekly units based on work tasks.
Task 4: Design Database and System Architecture
Draw an Entity-Relationship (ER) diagram.
Use standard web architecture design methodologies.
Task 5: Develop a Scalability and Standardization Plan
Ensure system quality and scalability.
Task 6: Define Maintenance Procedures and Recovery Plan
Establish maintenance guidelines.
Develop a data recovery plan.
Project 2: Web-Based School Management System
System Overview
The school management system will record information about students, teachers, courses,
classrooms, and school resources. It will also store student grades and allow teachers to view
class schedules.
Business Rules
Students, teachers, courses, and classrooms must be registered in the system.
The system should allow searching for students, teachers, or courses.
The system should list registered records, including students, teachers, classrooms, and
courses.
Teachers must be able to enter student grades.
Privileged users should be able to update and delete records.
A login form should be included for user authentication.
Tasks to Perform
Task 1: Folder Structure and Webpage Development
Create a folder named "school site" and store all project files inside.
Develop the following web pages with navigation links:
o index.html
o student.html
o teacher.html
o course.html
o Student Registration Form
o Course Registration Form
o Teacher Registration Form
Task 2: Backend Development
Write server-side scripts for the following functionalities:
o User Authentication: Verify login credentials using a database table.
o Data Insertion: Insert student, teacher, and course records into the database.
o Search and Retrieval: Retrieve student or teacher profiles based on their ID.
o Display Teacher List: Fetch and display all teachers from the database.
o Delete Records: Implement functionality to delete a student record.
Task 3: Data Protection and Recovery
Install and periodically scan the system for security threats.
Regularly back up and restore the database.
Enable remote access to the web-based system.
Database Schema
Create a database named "school" on the desktop and define the following tables:
Student Table (Stud_table)
Stud_ID Stud_name Age Sex
S001 Alemu 20 M
S002 Megersa 22 M
S003 Kebede 30 M
S004 Helen 23 F
Teacher Table (Teach_table)
T_ID T_Name Major
T001 Kemal Mathematics
T002 Ujulu IT
T003 Hassen Physics
T004 Bikila English
Course Table (Course_table)
Co_ID C_Name Department
C001 Algebra Mathematics
C002 Database IT
C003 Geophysics Physics
C004 Spoken English
Form and Page Requirements
Each registration page must include:
Name
ID
Major
Sex
Year of Study (if applicable)
Register and Update buttons
