Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ICT701 Relational Database Systems

tag 0 Download 9 Pages / 2,108 Words tag 17-12-2020

Question:

For Part A you are to include a word document or PDF that contains: - ER Diagram in Crows Foot notation (including primary & foreign keys) - Ensure normalisation of database to 3rd Normal Form - Assumptions that explain important design choices you made. For Part B you are to submit - A single plain text file, name _ABC.sql. In this file you are to include all the SQL for your implementation. This includes: o CREATE TABLEstatements including all integrity constraints, and actions on update and delete o INSERT INTO statements for populating the database based on trial data from appropriate forms.
 
(if this must happen in a particular order then make sure you order itappropriately!). Note: There is a sample completed Abbreviated CV (Appendix C). However, you must come up with and insert 5 additional staff members and corresponding sample data yourself to test the database you created. o The following queries and trigger:
• SELECT: List the Staff ID, title, name (first and last together) and highest qualification for all staff ordered by the lastname.
• SELECT: All staff that have not been approved to teach. Display the Staff ID, title, name (first and last together), approval notes.
• SELECT: All staff that have had no teaching experience
• SELECT: Display the total number of staff grouped by the AQF qualification level
• TRIGGER: When a staff member has been approved (i.e. when the staff approval date is updated – after update on staff table), the review date should automatically be inserted to be 1 year from the approval date. o CREATE INDEX statements for the Staff and Approval tables.Specific Instructions As the organisation is new, there is no actual data yet.
 
They plan to collect data via the Abbreviated CV (Appendix B). There is a sample completed Abbreviated CV (Appendix C). However, you must also create 5 additional sample data yourself to test the database you create. Basically, you will be inserting 5 fictional people and corresponding information into the database. You must use MySQL to develop the database. MS Access is not appropriate for any section of this assignment. You must use the ER notation that was taught in . Penalties will apply to incorrect notations.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 9 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Relational Database Systems. Retrieved from https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/employment-experience.html.

My Assignment Help (2020) Relational Database Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/employment-experience.html
[Accessed 05 October 2022].

My Assignment Help. 'Relational Database Systems' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/employment-experience.html> accessed 05 October 2022.

My Assignment Help. Relational Database Systems [Internet]. My Assignment Help. 2020 [cited 05 October 2022]. Available from: https://myassignmenthelp.com/free-samples/ict701-relational-database-systems/employment-experience.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?