need A+ work
sajhal-1
assig.zipassig/Assignment 2.docx
Assignment 2: LASA 1: Designing a Human Resources Database
Description of LASA:
For this assignment, you will design a basic human resources database for a fictional software company.
Scenario:
You are a freelance database designer who has just been contacted by a small software development company named Altair Software. The president of the company has asked you to create a database that will house employee information. The company currently has eight employees and comprises one president, two vice presidents, three programmers, and two sales representatives. The company wants you to create a scalable database that will grow as the company grows. They want to store the following information within the database:
|
Information Required |
Maximum Value |
|
Employee ID |
6 integers |
|
Employee Last Name |
30 characters |
|
Employee First Name |
30 characters |
|
Street Address |
60 characters |
|
City |
30 characters |
|
State |
2 characters |
|
ZIP Code |
5 integers |
|
Department |
30 characters |
|
Manager |
60 characters |
|
Position |
30 characters |
|
Salary |
8 integers |
The president of the company has given you a document that contains all of the above information for each employee. Click here to view the document having employee information.
Tasks:
You need to create spreadsheets in Microsoft Excel that accomplish the following:
1. Display a database table in first normal form that will store all of the information listed above. Identify a field or fields to act as the primary key bybolding that field name. Enter all of the provided information into the table in the spreadsheet.
Save your spreadsheet as M3_A2_Lastname_Firstname_FirstNormalForm.xls.
2. Decompose the table you created in Step 1 to second normal form. Place each table in its own sheet within the spreadsheet. Identify a field or fields to act as the primary key in each table by bolding that field name. You may insert a new field to act as the primary key if you feel it is warranted. Enter all of the provided information into the appropriate table in the spreadsheet.
Save your spreadsheet as M3_A2_Lastname_Firstname_SecondNormalForm.xls.
3. Decompose the table or tables you created in Step 2 to third normal form. Place each table in its own sheet within the spreadsheet. Identify a field or fields to act as the primary key in each table by bolding that field name. You may insert a new field to act as the primary key if you feel it is warranted. Enter all of the provided information into the appropriate table in the spreadsheet.
Save your spreadsheet as M3_A2_Lastname_Firstname_ThirdNormalForm.xls.
In addition, in a 2- to 3-page Microsoft Word document, you need to:
· Share your planning strategy to complete the database.
· Create an entity-relationship diagram from the tables that you designed above using crow's foot notation. Be sure to note the cardinality and modality for each relationship.
· Explain why you selected the links between each of the database tables.
assig/LASA1_EmployeeInformation.pdf
Page 1 of 2 Database Fundamentals
© 2013 Argosy University
Employee Information Employee ID : 100 Employee Last Name : Doe Employee First Name : Janet Street Address : 312 Maple Drive City : Anytown State : AZ ZIP Code : 85331 Department : EXEC Manager Name : Janet Doe Position : President Salary : 100000 Employee ID : 110 Employee Last Name : Smith Employee First Name : John Street Address : 1200 First Street City : Anytown State : AZ ZIP Code : 85331 Department : MGMT Manager Name : Janet Doe Position : Vice President Salary : 60000 Employee ID : 111 Employee Last Name : Smith Employee First Name : Jane Street Address : 4989 Hightower Lane City : Sometown State : AZ ZIP Code : 85332 Department : MGMT Manager Name : Janet Doe Position : Vice President Salary : 60000 Employee ID : 206 Employee Last Name : Smith Employee First Name : Arlene Street Address : 12 Acacia Avenue City : Anytown State : AZ ZIP Code : 85331 Department : DEV Manager Name : John Smith Position : Programmer II Salary : 45000
Page 2 of 2 Database Fundamentals
© 2013 Argosy University
2
Employee Information
Employee ID : 209 Employee Last Name : Smith Employee First Name : Bob Street Address : 687 Canyon Street City : Sometown State : AZ ZIP Code : 85332 Department : DEV Manager Name : John Smith Position : Programmer I Salary : 35000 Employee ID : 210 Employee Last Name : Smith Employee First Name : Cindy Street Address : 1209 Pine Tree Lane City : Sometown State : AZ ZIP Code : 85332 Department : DEV Manager Name : John Smith Position : Programmer I Salary : 35000 Employee ID : 323 Employee Last Name : Smith Employee First Name : David Street Address : 5435 Main Street City : Anytown State : AZ ZIP Code : 85331 Department : SALES Manager Name : Jane Smith Position : Sales Representative Salary : 25000 Employee ID : 330 Employee Last Name : Smith Employee First Name : Eric Street Address : 3 Post Drive City : Sometown State : AZ ZIP Code : 85332 Department : SALES Manager Name : Jane Smith Position : Sales Representative Salary : 25000
assig/Rubric - Database Fundamentals.docx
Grading Criteria and Rubric
LASA 1: Designing a Human Resources Database
Note: If a component is absent, student receives a zero for that component.
|
Assignment Components |
Unsatisfactory
|
Emerging
|
Proficient
|
Exemplary
|
Score |
|
Created a Microsoft Excel spreadsheet that displays a database table in first normal form that will store all of the information listed above. CO: 1, 2, 3 ASIT PO: 2.b, 3.a, 3.b, 4.d BSIT PO: 2.b, 3.a, 3.b, 4.c, 4.e ILO: 1, 2, 3, 6 |
Spreadsheet may not display information in first normal form. Information within the spreadsheet is inaccurate, missing, or extremely unorganized. No data field, or an inappropriate data field, was selected as the primary key. |
Spreadsheet displays information in first normal form. Information within the spreadsheet is accurate. All relevant information is included. A data field was selected as the primary key. |
Spreadsheet displays information in first normal form. Information within the spreadsheet is accurate and organized. All relevant information is included. An appropriate data field was selected as the primary key. |
Spreadsheet displays information in first normal form. Information within the spreadsheet is accurate, comprehensive, and professional. All relevant information is included. The style of the spreadsheet is likely to be used in a professional setting. An appropriate data field was selected as the primary key.
|
36 |
|
Created a new Microsoft Excel spreadsheet and decomposed the table created in Step 1 to second normal form. Placed each table in its own sheet within the spreadsheet.
CO: 1, 2, 3 ASIT PO: 2.b, 3.a, 3.b, 4.d BSIT PO: 2.b, 3.a, 3.b, 4.c, 4.e ILO: 1, 2, 3, 6
|
Spreadsheet may not display information in second normal form. Information within the spreadsheet is inaccurate, missing, or extremely unorganized. Each table is not in its own sheet within the spreadsheet. No data field, or an inappropriate data field, was selected as the primary key in each table. |
Spreadsheet attempts to display information in second normal form. Information within the spreadsheet is accurate. All relevant information is included. Each table is in its own sheet within the spreadsheet. A data field was selected as the primary key in each table. |
Spreadsheet displays information in second normal form. Information within the spreadsheet is accurate and organized. All relevant information is included. Each table is in its own sheet within the spreadsheet. An appropriate data field was selected as the primary key in each table. |
Spreadsheet displays information in second normal form. Information within the spreadsheet is accurate, comprehensive, and professional. All relevant information is included. The style of the spreadsheet is likely to be used in a professional setting. An appropriate data field was selected as the primary key in each table. |
40 |
|
Created a new Microsoft Excel spreadsheet and decomposed the tables created in Step 2 to third normal form. Placed each table in its own sheet within the spreadsheet. CO: 1, 2, 3 ASIT PO: 2.b, 3.a, 3.b, 4.d BSIT PO: 2.b, 3.a, 3.b, 4.c, 4.e ILO: 1, 2, 3, 6
|
Spreadsheet may not display information in third normal form. Information within the spreadsheet is inaccurate, missing, or extremely unorganized. Each table is not in its own sheet within the spreadsheet. No data field, or an inappropriate data field, was selected as the primary key in each table. |
Spreadsheet attempts to display information in third normal form. Information within the spreadsheet is accurate. All relevant information is included. Each table is in its own sheet within the spreadsheet. A data field was selected as the primary key in each table. |
Spreadsheet displays information in third normal form. Information within the spreadsheet is accurate and organized. All relevant information is included. Each table is in its own sheet within the spreadsheet. An appropriate data field was selected as the primary key in each table. |
Spreadsheet displays information in third normal form. Information within the spreadsheet is accurate, comprehensive, and professional. All relevant information is included. The style of the spreadsheet is likely to be used in a professional setting. An appropriate data field was selected as the primary key in each table. |
40 |
|
Shared your planning strategy to complete the database. Created an entity-relationship diagram from the tables designed above using crow’s foot notation. Noted the cardinality and modality for each relationship. CO: 1, 3, 4, 5 ASIT PO: 2.a, 3.a, 3.b, 4.a, 4.d BSIT PO: 2.a, 3.a, 3.b, 4.c, 4.e, 5.c ILO: 1, 2, 3, 6
|
Planning strategy to complete the database has not been shared. The relationship between all entities is inaccurate or extremely unclear. The relationships between entities and the cardinality and modality are incorrect or missing. |
Planning strategy to complete the database is shared. However, it is ambiguous. The relationship between all entities is accurate, but may be unclear or vague. The relationships between entities and the cardinality and modality are identified. |
Planning strategy to complete the database is shared. The strategy is clear and precise. The relationship between all entities is clear and specific. The relationships between entities and the cardinality and modality are accurately identified. |
Planning strategy to complete the database is shared. The strategy is explained in detail. The relationship between all entities is clear and comprehensively explained. The relationships between entities and the cardinality and modality are accurately identified and comprehensively explained. |
40 |
|
Writing Components |
|||||
|
Organization: Introduction, Thesis, Transitions, Conclusion CO_W PO: 3.a ILO 2 |
Introduction is limited or missing entirely. The paper lacks a thesis statement. Transitions are infrequent, illogical, or missing entirely. Conclusion is limited or missing entirely.
|
Introduction is present but incomplete or underdeveloped. The paper is loosely organized around a thesis that may have to be inferred. Transitions are sporadic. Conclusion is present, but incomplete or underdeveloped.
|
Introduction has a clear opening, provides background information, and states the topic. The paper is organized around an arguable, clearly stated thesis statement. Transitions are appropriate and help the flow of ideas. Conclusion summarizes main argument and has a clear ending.
|
Introduction catches the reader’s attention, provides compelling and appropriate background info, and clearly states the topic. The paper is well organized around an arguable, focused thesis. Thoughtful transitions clearly show how ideas relate. Conclusion leaves the reader with a sense of closure and provides concluding insights. |
44 |
|
Usage and Mechanics: Grammar, Spelling, Sentence structure CO_W PO: 3.a ILO 2 |
Writing contains numerous errors in spelling, grammar, and/or sentence structure that severely interferes with readability and comprehension. |
Errors in spelling and grammar exist that somewhat interfere with readability and/or comprehension.
|
Writing follows conventions of spelling and grammar throughout. Errors are infrequent and do not interfere with readability or comprehension. |
The paper is basically error free in terms of mechanics. Grammar and mechanics help establish a clear idea and aid the reader in following the writer’s logic. |
|
|
APA Elements: Attribution: Paraphrasing: Quotations CO_W PO: 3.a ILO 2 |
No attempt at APA format. |
APA format is attempted to paraphrase, quote, and cite, but errors are significant. |
Using APA format, accurately paraphrased, quoted, and cited in many spots throughout when appropriate or called for. Errors present are minor. |
Using APA format, accurately paraphrased, quoted, and cited throughout the presentation when appropriate or called for. Only a few minor errors present. |
|
|
Style: Audience, Word Choice CO_W PO: 3.a ILO 2 |
Writing often slips into first and/or second person. Word choice is consistently inaccurate, unclear, or inappropriate for the audience.
|
Writing sometimes slips into first and/or second person. Word choice is sometimes inaccurate, unclear, or inappropriate for the audience. |
Writing remains in third person throughout. Word choice is accurate, clear, and appropriate for the audience. |
Writing remains professional in third person throughout. Word choice is precise, appropriate for the audience, and memorable. |
|
|
Total |
200 |
