Create “ Schools database” using MS-Access. Make relevant assumption for designing the Database.
Creating a "Schools Database" using Microsoft Access involves careful consideration of the data structure and relationships between different entities within the educational system. Here's a simplified example with relevant assumptions for designing the database:
Entities and Assumptions:
1. Schools: Each school is a distinct entity with attributes such as SchoolID (unique identifier), SchoolName, Address, PrincipalName, and ContactNumber.
2. Teachers: Assume that each school employs multiple teachers. Each teacher has attributes like TeacherID, FirstName, LastName, ____ ______ _______ ____ ____ _____ _______.
________ __________ _____ _______ ______ __________ _______ ___ ___ _______ __________ _____.
____ __________ ___ ___ ____ _______ _______.
____ __________ ____ ______ ________ _________ _________ ____ _____ _____ ______.
_____ ___ ________ _______ __________ ________ ______ ___ _______.
_______ _____ _____ _______ ___ __________ _________ ___ ___ _____ _______ _________.
_________ ___ ________ _______ ____ _____ _____ ______ _____ ________ _______ __________.
____ ______ _________ ______ _________ ___.
________ ______ _________ ________ ____ __________ ______ ______ _________ _____ ______.
____ ____ _____ _____ _____.
_____ __________ __________ ______ ____ _____ __________ ___ _________ _____ _____ _________.
_____ _________ _____ __________ ____ ________ _________ _______ ________ ____ ___.
___ _________ _________ ___ ____ ___ ____ _________ __________ ________ ___.
_________ __________ ______ ________ _________ _______ ____ ___ ________ ___.
__________ ________ ____ ____ ______ ___ __________ ______ ________ _________ ______.
__________ ______ ____ _________ ______ _____ ___ ________ _________ ____ ___.
__________ ______ _________ __________ ______ _________ ____ ____ ________ ___ __________.
____ _________ ________ _______ _________.
___ _____ _______ _______ _________ ____.
______ _____ __________ ________ __________ ______ ________ ______ ______.
____ ____ ______ _________ ______ ____ ___ ________ __________ ____ ________ ______.
________ ____ ________ _________ ____ _______ ___ _______ ___ __________ __________ ______.
______ ____ ________ _________ ______ _________ __________.
____ _______ ___.
Get Full Answer on WhatsApp