Your database system must be based on the specifications and requirements that follow. [url removed, login to view] Users
The users of your system will be the job seekers who upload their resumes to Your website: companies who upload descriptions of job openings; and various employees of your web site: customer representatives who arrange interviews and provide other customer-related services, and the web site's manager. You should assume that the computer knowledge of the users is limited (say, that of a typical intermet subscriber), and thus your system must be easy to access and operate.
[url removed, login to view] Data
the data items required for your database can be classified into six categories: resumes, Job companies,job categories, interviews, and employees (of the website) This classification does not imply any particular table arrangement. You are responsible for arranging the data items into tables, determining the relationships among tables and indentifying the key attributes. In addition, you should specify and enforce integrity constraints on the data, including referential integrity constraints. However, before you begin thinking about your relational model, you should first create an E-R diagmm of your database system.
2.1 Resume Data
The items required for this category include: 1. Social Security no. 2. Last Name 3. First Name 4. Street Address 5. City 6. State 7. Zip Code 8. Credit Card no. 9. E-Mail Address 10. Document (the actual resume) 11. Date Posted 12. Image (of the job seeker) 13. Audio Gritting (optional) 14. Desired Job Categories 15. Outstanding Balance Job seekers can post their resumes on your web site and indicate the kinds of jobs they are interested in. They can also browse your web site for job descriptions; when they find a job they are interested in. they can request an interview. Each time your web site arranges an interview for a job seeker, he or she will be charged $1. A job seeker has the option of attaching an audio greeting to his or her resume.
2.2 Company Data
The items required thr this category include: 1. Company Id 2. Company Name 3. Street Address 4. City 5. State [url removed, login to view] Code 7. Telephone 8. Job Description Supplied 9. Contact Person 10. Contact Phone number 11. Outstanding Balance Companies may post job descriptions on your web site and browse the site for resumes of perspective employees. If our see resume they like, they can request an interview with the job seeker each time your web site arranges an interview for a company, the company will be charged $10.
2.3 Job Description
Data items required for this category include: 1. Job Description ID 2. Title 3. Date Posted 4. Document (actual job description) 5. Job Category 6. Company
2.4 Job Category Data
The items required for this category include: 1. Job Category ID 2. Job Category Name Job categories list all job types.
2.5 Interview Data
The items required for this category include: 1. Interview ID 2. Company 3. Job Seeker 4. Date/time 5. Customer Representative
An interview is between a company and a job Seeker. YOU should assign a customer representative of your website to arrange/oversee each interview.