Re: Help with query for school project please!
You should start a database project (any project really) with a clear statement of the requirement.
The simpler you can describe the entire problem/opportunity, the better you understand the situation.
I see nothing in your post that suggests or explains the need for Employee, WorkOrder, DiniingHall,
Laundry or RecreationRoom.
They all could be in scope, but should be placed in context before building a model or database.
Here's an example from RogersAccessLibrary:
ZYX Laboratories requires an employee tracking database. They want to track information
about employees, the employee's job history, and their certifications. Employee information includes first name,
middle initial, last name, social security number, address, city, state, zip, home phone, cell phone, email address.
Job history would include job title, job description, pay grade, pay range, salary, and date of promotion.
For certifications, they want certification type and date achieved.
An employee can have multiple jobs over time, (ie, Analyst, Sr. Analyst, QA Administrator).
Employees can also earn certifications necessary for their job.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.