Question

Consider the following relational schemas for a company database:

  • Employees (EmpID, EmpName, Salary, DeptID)

  • Departments (DeptID, DeptName)

  • Projects (ProjID, ProjName, Lead_EmpID)


  •  
12 Sep 2025
Answer :
Word Count : 301
The given relational schemas for a company database represent three main entities: employees, departments, and projects. The Employees table contains attributes EmpID, EmpName, Salary, and DeptID. Here, EmpID is the primary key that uniquely identifies each employee. DeptID acts as a foreign key that establishes a relationship with the Departments table, ensuring that each employee belongs to a valid department. This schema helps in maintaining employee details such as names, salaries, and the department to
________ _________ __________ _______ _____ ________ ________ ___ ____ _______ ___.
___ __________ ____ ________ ____ ___ ___ _______ ________ ___ ____ ______.
_______ ____ _____ _____ _______ ____ _________ ___.
__________ ___ _____ _________ ______ _________ __________ ___ _______ ___ _____ ___.
_________ ________ _______ ______ __________.
_________ ________ _____ _________ ___ ________ __________ _________ _______ ___ _____.
_____ _________ _________ ______ _____ ____ ______ ________ __________ ____ ________.
____ ______ __________ _____ __________ ______ __________ __________ ___ _________ _____.
______ ___ ______ _________ _____ ________.
__________ ______ ___ _______ _______ ______ ___ __________.
__________ ___ _____ __________ ______ _________ ____ _____ ________.
____ _______ ______ ____ ____ ______ _________ _______.
__________ ___ __________ _____ ___.
________ _________ __________ _________ ________.
___ ______ ______ ________ ______ ________ _____ ______ _________ _________ __________ ____.
________ ______ ______ _____ ___ __________ ______ ____ ______ ____ _______ _______.
______ _______ _________ __________ _______ _______ ________ _______.
_______ ________ ______ _________ _______ _________ __________ _______ _________ _________.
______ ________ __________ _______ ____ _______ ________ ________ ___.
______ _________ ______ _______ ______ _______ _____ _______ _________ ________.
________ ___ _____ _________ _____ _____.
________ _________ __________ _____ ____ ____ ___.
___ __________ ______ _______ ____.
__________ ___ _________ __________ ____ ____.
_________ ____ ___ _____ ___ ___ __________ ______ _____ ________.
_________ ______ _________ _________ _______ _______ _________ __________.
________.
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 MCS 23 2025 2026 - Consider the following relational schemas for a company database: | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→