University | PSB Academy (PSB) |
Subject | DATABASE DESIGN AND MODELLING Assignment |
Project: Database Design For Project Management You’re Appointed As Database Administrator To Stamford Consulting: DATABASE DESIGN AND MODELLING Assignment, PSB Academy, Singapore
ASSIGNMENT REQUIREMENT
Project: Database Design for Project Management
You’re appointed as Database administrator to Stamford 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 on by employees
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
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.
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
Key in appropriate records for all the tables. (Sample, take from the project report given and add further meaningful records in the derived tables.)
1) Display Employee Name belongs to department either IT or Finance
2) Count No of Employees whose Hourly rate above 50
3) Find employee names starts with ‘S’
4) Display Department Name and Sum of Hourly Rate for each Department.
Sample Output:
Department Name Total Hourly Rate
Finance $125
HR $110
IT $175
5) Display department name with Number of employees less than 5 Numbers
6) Display Employee name and Department name, who has maximum and minimum salary
7) Display No of employees , Department name in each department.
Note: Use SQL software, Do Joins in query wherever applicable. All the tables with data and SQL query along with its output for each task should be provided in word file
Buy Custom Answer of This Assessment & Raise Your Grades
Seeking academic success in Singapore? Look no further than Assignment Helper. Our experts specialize in individual assignments, offering tailored support for your academic needs. Tackling the challenging DATABASE DESIGN AND MODELLING Assignment at PSB Academy? Entrust your project, especially the intricate task of "Database Design for Project Management," to our skilled team. Say "Do My Assignment Singapore" confidently and pay for personalized assistance, ensuring a seamless academic journey at PSB Academy.
Tags:-
- Imagine that you are currently working for a precision medicine startup: Machine Learning Paper Review in Precision Medicine, Written Assignment 1, NUS, Singapore
- Go Business offers PSG solutions for enterprises in Singapore: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Design an ontology based on- Accidents can be categorised as chemical, electrical, fire, kinetic or liquid: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Project Control Monitoring, Assignment, HU, Singapore: Deliberate Project MONITORING AND CONTROL or PMC Identification
- DSM500: Final Project Report, Coursework 2, UOL, Singapore
- DSM080: Financial Markets, Assignment, UOL, Singapore: A grapefruit juice futures contract is for 15,000 pounds of frozen grapefruit juice
- DSM080: Financial Markets, Assignment, UOL, Singapore: The share price of a certain stock today is $42.50, and five-month European style call options with a strike price of $45 currently sell for $4.25.
- DSM080: Financial Markets, Assignment, UOL, Singapore: A trader who is working in the gold markets is able to borrow money at the interest rate of 7% per annum
- DSM080 Financial Markets, Assignment, UOL, Singapore: A dollar-based American corporation has decided that it will have to pay 6 million UK pounds in three months
- Principle of Finance Assignment, UCD, Singapore: National Gaming Inc. (National) operates the weekly lottery in the country
UP TO 15 % DISCOUNT