Database Administration assignment.

I need assistance in completing a Database Administration assignment. The work should be presented in a report format with clear explanations, diagrams, SQL queries, and references in Harvard style.

The project is divided into 3 main tasks:

⸻

TASK 1 – Database Fundamentals (Report, 500+ words)
• Compare and contrast File System vs Database
• Explain different database models with examples
• Explain E-R Model and the symbols used (with diagrams)

⸻

TASK 2 – SQL Queries & SELECT Command (Report, 500+ words + SQL code)
• Write SQL queries for the given schema:
• Find oldest teacher
• Teachers with salary equal to those who joined before 31-Dec-1994
• Teachers with salary greater than any teacher with job title “Programmer”
• Teachers with same job title and salary as “Muhammed”
• Explain syntax and working of SELECT command with examples
• (Requirement: screen recording of query execution must be included as a separate file)

⸻

TASK 3 – DBMS Concepts (Report, 500+ words)
• Explain Key constraints and different types of keys in DBMS
• Explain Normalization (1NF, 2NF, 3NF, BCNF) with examples
• Explain and demonstrate join operations in relational algebra (with examples & diagrams)
• Describe ACID properties of transactions in DBMS with examples

⸻

Deliverables:
1. Report (Word or PDF)
• Minimum 500 words per task
• Proper formatting with diagrams and explanations
• References in Harvard format
2. SQL query files + Screen recordings of query execution
3. Relevant diagrams (E-R model, normalization tables, join diagrams, etc.)