University | PSB Academy (PSB) |
Subject | Database Design and Modeling |
OVERVIEW
In this assignment student will demonstrate their understanding in relational database design and modeling by completing a project assigned. Students will also demonstrate their skills in implementing the design database and perform data entries, date retrieval and data manipulation using with Structured Query Language (SQL).
ASSIGNMENT REQUIREMENT
Project: Database Design for Human Resource – Project Management
You’re appointed as Database administrator to Harvest consulting. Your first assignment is to advise your client on how to manage human resources for projects. Your ideas to include how to analyze the logical database design, physical data model, establish relationship, create tables, and manipulate records using Data definition and data manipulation language
You and your team are highly advised to conduct some research and to get better understanding on human resource data in relation to project management. You may refer to advised reference books in the course and internet resources.
Below is the Project Management Report, which describes projects being worked upon by employees.
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Native Singapore Writers Team
- 100% Plagiarism-Free Essay
- Highest Satisfaction Rate
- Free Revision
- On-Time Delivery
Task 1 – Convert the Report from un-normal form into third normal form. Provide appropriate name for each Entities and attributes. Find the primary, Foreign and composite keys. 15 Marks
Note:
- Find Un-Normalized form data
- Convert un-normalized set to 1NF
- 1NF to 2NF
- 2NF to 3NF
- In between the process of normalization find out Primary, foreign and Composite keys.
- Discuss the steps of normalization while carrying each NFs.
- Use appropriate tool to do the task
Buy Custom Answer of This Assessment & Raise Your Grades
Task 2
1) Key in appropriate records for all the tables. (Sample, take from the project report given and add further meaningful records in the derived tables. Note: Minimum 20 records in Employee table and other tables any number of records)
2) Display Employee Name belongs to department either IT or Finance
3) Count No of Employees whose Hourly rate above 50
4) Find employee names starts with ‘S’
5) Display Department Name and Sum of Hourly Rate for each Department.
Sample Output:
- Department Name
- Total Hourly Rate
- Finance
- $125
- HR
- $110
- IT
- $175
6) Display department name with Number of employees less than 5 Numbers
7) Display Employee name and Department name, who has maximum and minimum salary
8) Display No of employees, Department name in each department.
9) Create a procedure to display Employee Name and Department Name whose Hourly rate is above 100.
10) Demonstration of Task1 and Task 2 for 5 minutes by Lesson 9/ Lesson 10 in class.
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
Stressed about DICT Database Design and Modeling Individual Assignment? Our assignment help service in Singapore is here to provide reprieve and easiness to you. Singaporean students can pay someone to do my assignment for me and get expert help in coursework. We offer precise Tutor Marked Assignment Answers for a chance at the best grades. Don't let the assignment drive you up the wall; reach out to us for experienced help and receive all the assistance you need to score top in your class!
Looking for Plagiarism free Answers for your college/ university Assignments.
- ANL303 Data Analysis of Diabetes: Exploring K-Means and Apriori Models for Patient Profiling, GBA
- HRM335 Exploring Leadership Adaptability: Insights from Industry Leaders (GBA)
- ELG101 Linguistic Analysis of Affixes, Word Formation, Syntax, and Social Media’s Impact on Language (TMA02)
- MTH355 Solving Linear Equations and Optimization Using LU Decomposition and Linear Programming, TMA
- PSY352 Cultural Evolution And Persistence in a Changing World, ECA
- CMM315 The Rwandan Genocide and Peacebuilding Efforts, ECA
- HRM335 Reflecting on Leadership Experiences: Connecting Theory to Practice (TMA02)
- MGT568 Agile Leadership in CEO Succession Planning: Strategies for Organisational Success (ECA)
- MGT568 Agile Leadership Scenario Planning: Strategies for Business Resilience
- GSP165 Legal Principles in Divorce, Child Custody & Estate Distribution