Build a Website

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, A job seeker has the option of attaching an audio greeting to his or her resume. 2. Company Data The items required thr this category include: 1. Company Id 2. Company Name 3. Street Address 4. City 5. State [login to view URL] 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. 2.1 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.2 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.3 Interview Data The items required for this category include: 1. Interview ID 2. Company 3. Job Seeker 4. Date/time An interview is between a company and a job Seeker. 2.4 Employee Data The items required for this category include: 1. Employee ID 2. Last Name 3. First Name 4. Title 5. Street Address 6. City 7. State 8. Zip Code 9. Telephone 10. Start Date [login to view URL] You will be required to supplement your completed database implementation with a design document that contains information concering your design criteria and decisions. The following is a list of some of the information you should include: • Entity-Relationship (E-R) Dingman of the complete database scheme • The relational database scheme of your web site's database. Make Sure that your design supports all query transactions. • A list of all functional dependencies in the relational database scheme • Description of integrity constraints including referential integrity. You will also be required to submit a Users Guide that carefully explains how to use all aspects of the system. It should be understandable by non-computer experts. Be sure that the user interface(screen design,menu structure, etc.) is clearly explained