Ireland Assignments .ieIRELAND.ieASSIGNMENTS
Order Now Log In
  • Home
  • Services
    Writing Services
    • Essay Writing Services
    • Dissertation Writing
    • Thesis Writing Service
    • Literature Review Writing
    • Research Paper For Sale
    • Report Writing Assistance
    • Do My Assignment
    • Write My Essay
    • Buy Assignments Online
    • Irish Homework Help
    AI Support & Referencing
    • Assignment Review Service
    • AI-Free Assignment Help
    • Remove AI From Your Assignment
    • Citation and Referencing Help
    • AI Guidance for Students
    Assignment Type
    • Learner Record Writing
    • Skill Demonstration Assignments
    • Work Experience Diary
    • Reflection Journal
    • Online Exam Help
    • QQI Level 5
    • QQI Level 6
    Course
    • Nursing
    • Childcare
    • Healthcare
    • SNA (Special Needs)
    • Care of Older People
    • Child Development
    • Care Skills
    • Care Support
    • Disability Awareness
    • Infection Prevention
    • Health & Safety at Work
    Online Degree Course
    • Psychology Assignments
    • Early Childhood QQI Assignments
    • Montessori Assignments
    • Palliative Course Assignments
    • Communications FETAC Level 5 Assignments
    • Law Course Assignments
    • Management Assignments
    • Train the Trainer
    • Healthcare Assistance
    • Digital Marketing Assignment
    • QQI Assignments
    Cities
    • Dublin
    • Galway
    • Cork
    • Limerick
    • Waterford
    • Sligo
    • Dundalk
    • Carlow
    • Maynooth
  • Samples
  • Experts
  • Questions
  • Blog
  • Reviews 4.9/5
Order Now Log In
Search from Thousands of
Ireland Assignments Answers
  • 463+ Experts
  • A+ Grade
  • Free Turnitin Report
  1. Home
  2. Questions
  3. Oracle SQL Assignment (coursework) – Homework is the development of software for recording the projects

Oracle SQL Assignment (coursework) – Homework is the development of software for recording the projects

Oracle SQL Assignment (coursework)

Scenario

Consider that you are the team of founders of a new IT company. Your homework is the development of software for recording the projects and the progress of each project that the company will undertake.
The company will be engaged in undertaking software projects. The aim is to fully record all the details of these projects and to systematically monitor them for the entire period from the initial discussions to the analysis, implementation and final delivery of the project.
Homework is the implementation of a DataBase where this information will be stored. Starting from the initial finding of a project, it is necessary to record the details of the potential customer, the type of the business and to categorize the type of project to be taken over.
Then, all the contact information (who spoke to whom and on what matter, which documents were exchanged, if there are deadlines at each stage, who is responsible for the company, etc.) will be stored in the Base so that there can be follow up and monitoring in Communication. Of course, it is also necessary to define who will be responsible for the communication, that is to say, that the company’s employees should have an exclusive understanding with the customer.
The next step is to take or reject a project (with similar reasoning and of course dates). In case of a takeover, the project timetable (projects – sub-projects – work with calculated and spent man-hours) will be kept in the Base, who has undertaken to implement them, who are the project managers in each project and of course, there will be a graduation performance of each employee.
At the same time, financial data will be stored on the project (and any subdivision) and financial earnings of employees. The goal is to prove at the end of the project if the compared project was profitable or not.
Based on all of the above, you will need to design and implement a system that, among other things, must meet the following requirements:
1) Have appropriate tables so that all data can be stored

2) Record the salary of staff and which can not be less than 800 € and not more than 5000 €
3) For each employee, his / her specialty and his / her occupation must be recorded
4) An employee will not be allowed to take part in more than 2 projects in parallel.
5) Customer and employee information in the email field should check whether or not you include the @
6) For projects, the expiration date can not be before the start date (the same applies to each subdivision of the project)
7) The Ids in each array must be generated automatically (auto increment) using sequence and trigger mechanisms

Deliverables
Your company should:
1) Design the system (production of ER diagrams and a list of all tables and columns) & Documentation
2) Implement it (SQL – Oracle Code / commands) Use of triggers & sequence
3) Input the data (demo data) and create lists of records for each table
4) Cost it
5) Draw SQL queries that will
i. Returns a list of employee details (Employees are considered AND owners !!!)
ii. Returns a list of projects sorted by date of withdrawal
iii. Returns a list of projects – subprojects – jobs sorted by the start date of each phase
iv. Returns the number of projects per status (active, discarded, completed, etc.)
v. Returns list of employees per project phase and duration of each phase (project code required)
vi. Returns the man-hours for each project by analysis per employee
vii. Returns financial details of the project: budget, the final cost of work in man-hours X man-hours cost, employee’s work rate in the project, the final amount corresponding to his salary the engagement with this work

Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services

Get A Free Quote

Shared with
Ireland Assignments Editorial Team

A student shared this brief with our team; personal details have been removed. Our editorial team works on tasks like this and can guide you on how to approach it.

Get Help By Expert

irelandassignments.ie is here with its IT management assignment writings at the lowest possible price. Our writers are prominent in the field of academics and accomplish your work well. Receive the best help in coursework writing from our team of experts.

Submit Your Assignment Questions & Get Plagiarism Free Answers.

Buy Now
Get the Answer to This Question

Tell us about your assignment in 3 quick steps and get a free, no-obligation quote.

1 Basics 2 Details 3 Contact
The basics
Over 10,000 words? Choose 10,000+ and type your exact count.
Step 1 of 3 · takes under a minute
About your assignment
What help do you need?
Do you have the brief or marking rubric?
Step 2 of 3 · last step is your contact details
Where should we send your quote?
Attach your brief, rubric or notes (optional, up to 10 files)
PDF, Word, PowerPoint, Excel or images · up to 100MB in total
Uploading…
Free quote No payment to submit 100% confidential

To Get Answer
Please Fill the following Details

If you think the question is incomplete, then you can upload your assignment brief.

Facing Issues with Assignments? Talk to Our Experts Now!Download Our App Now!

Request a Call Back
Irish assignment expert ready to help a student

Have Questions About Our Services?
Download Our App!

Get the App Today!

iphone android
QRcode
Ireland Assignments .ieIRELAND.ieASSIGNMENTS

Ireland Assignments

Ireland Assignment's offers plagiarism free assistance to the students around the globe. We understand the value of top grades to a student. And that is the reason we are here to assist you with ultimate professionalism. By availing our services we assure you better grades. Raise your academic grades with our Ireland assignment help.

Useful Links

Useful Links

Useful Links
  • Home
  • Services
  • Samples
  • Blog
  • User Reviews
  • Questions
  • Experts
  • Submit Questions
Legal & Policies

Legal & Policies

Legal & Policies
  • Privacy Policy
  • Warranty
  • Copyright Notice
  • Terms & Conditions
  • About Us
  • Contact Us
  • How Ordering Works
  • University Assignment Help
  • Final Year Project Help
  • Semester Assignment Help
  • Social Care Project Help
  • Care of the Surgical Patient
Cities

Cities

Cities
  • Dublin
  • Galway
  • Cork
  • Limerick
  • Waterford
  • Sligo
  • Dundalk
  • Carlow
  • Maynooth
GDPR
info@irelandassignments.ie
Secure Payment

77 Camden Street Lower, Dublin, D2 XE80, Ireland

Student Login·Facebook

Disclaimer: Ireland Assignments provides academic assistance to students so that they can complete their university assignments and projects on time. Our business does NOT deal with ghostwriting services as we are aware of this being one of the academic misconducts. But we do help students by connecting them to online subject experts within an affordable price range. Also, if you're looking for high-quality resources such as journals and articles, pdf files, videos, research papers, e-books, and other secondary literature to write your assignment task, then we can certainly help you out. Ireland Assignments is not sponsored or endorsed by (Ireland) Quality and Qualification Ireland or any college or university in Ireland or elsewhere in the world. All trademarks, logos and brand names are the property of their respective owners. All university related assistance services, materials and their names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

Ireland Assignments rated 4.9/5 based on 15,000+ student reviews on WhatsApp

Copyright © 2026 Ireland Assignments, All Right Reserved