Project: Hospital Management System
Using relational algebra operations Select, Project, Cartesian Product, Union, Intersection, Difference, Division, Left Outer Join, Right Outer Join, and Join, write 6 queries for your project database. Make sure to explain each step. For example:
Query1: (Query Description)
Step1: Find all…..
SELECT ………..
Step2: combine ….. then extract …….
PROJECT (……………….CARTESIAN PRODUCT )
Etc.
Submit a Word document or PDF with the following sections:
Introduction – Restate problem and bullet point a high level description of your queries. Why are these queries useful?
Entity-attribute-table for all entities as well as associative entities.
Your queries and step by step explanations
An updated ERD
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|