Question

Design a "Student Information System" database using MS-Access Include tables for Students, Courses, and Enrolments. Make appropriate assumptions about the fields and relationships among these tables.

26 Jul 2025
Answer :
Word Count : 287
To design a "Student Information System" database using MS-Access, we need to create three main tables: Students, Courses, and Enrolments. Each table will include a primary key and relevant fields. Relationships will be established to maintain referential integrity. 1. Students Table: | Field Name | Data Type | Description | | ----------- | ---------- | ----------------------- | | StudentID | AutoNumber | Primary Key | | FirstName | Short Text | Student's first name | | LastName | Short Text | Student's last
__________ ___ _____ ______ _____ __________ ___ _______ _______ ________.
______ ___ ____ __________ __________ _____.
__________ _____ _______ __________ _________ _____ ______ __________ ______ ________.
_____ _______ _____ __________ ___ __________ ______ ____ ___ ___ _______.
_____ _______ __________ ____ _______ _________ __________ _____.
______ __________ ____ ____ ____.
____ __________ ______ ___ ____.
____ ____ ______ ______ ________ _______ _______ _________ ___ ___.
__________ _________ ________ _________ __________ __________ ____ __________.
___ __________ _________ ____ _________ _____ ____ ______ _________ ___ ________ _____.
____ _____ ___ ____ ___ _________ _________ ___ _____.
_____ __________ __________ ______ _________ ______ _____ _______ _______ __________.
_________ _____ ____ __________ ____ _________ ___.
__________ _______ ___ ________ ______.
_______ _________ ____ ________ ________ ___ _____ _________.
_______ __________ ________ _________ _____ ______.
_________ _______ ____ ___ _______ _____ ________ ___.
__________ ______ ___ ____ ___.
___ ________ ______ _______ _______ ________ ___ __________.
______ ________ ________ ___ _________ _____ _______ _________.
___ ____ _____ ________ _________ _________ ________ _______ _______ ______ ____.
_________ _____ ________ ___ __________ _____ _____.
______ _________ ______ ________ ____ ______ _________ _______ _______ _________.
________ ______ ____ ________ _______ ________.
______ ___ _________ _______ __________ ______ ________ _________ _________ _________.
_________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU CITL 1 2025 2026 - Design a "Student Information System" database using MS-Acce | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→