Connect on Whatsapp : +97143393999 , Uninterrupted Access, 24x7 Availability, 100% Confidential. Connect Now

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

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

ICTDBS502 Information Technology

tag 0 Download 5 Pages / 1,083 Words tag 21-11-2020
  • Course Code: ICTDBS502
  • University: Tafe NSW
    icon is not sponsored or endorsed by this college or university

  • Country: Australia


The IT section of Northern Beaches TAFE would like to build a database to track students in order to keep them informed about the course offerings.

They would like to keep information about students and potential students from the time they enquire, through enrolment and study and after they graduate.  This information will be used to:

  1. Send out details about information sessions and enrolments times to students who have enquired throughout the term.
  2. Send follow-up information to students who have attended information sessions.
  3. Send out details about new courses to existing students and graduating students.
  4. Follow up graduating students to analyse employment trends.


  • Create a list of questions to clarify the user needs. 
  • Submit these to Sakai and also email to your teacher.
  • Your teacher will act as the client and respond to these questions.
  • Take into account these responses when completing the rest of the assignment.

Create a ½ page document clarifying the objective, scope and boundary of this project.

  • Create a recommendation of the hardware and software requirements for the project.
  • Create an initial conceptual design diagram for the project.
  • Document any validation rules you think should be used.
  • Submit these to Sakai and also email to your teacher.
  1. After feedback from the teacher complete the final ER diagram, export to SQL script and import to SQL server. Make sure all tables are normalised, validation rules are set as required and referential integrity is set as required.
  2. Create any indexes you think would be useful.
  3. Create a data dictionary
  4. Enter some test data.
  1. Create a small example front-end in C# or other language to access the database.
  2. Create a query that will fulfil one of the original client needs and a report from that query.
  3. Create a report including:
    • An introduction.
    • The Objective, scope and boundary (you can copy and paste from the feasibility study).
    • The hardware and software recommendations – showing a calculation of the table sizes.  (even though you will be creating these in SQL server you can recommend another solution if you think it is more appropriate).
    • A screen capture of your ER diagram.
    • A screen capture of the front-end showing test data.
    • Security recommendations including password requirements.
    • Backup requirements.

NB the report should be written in correct report format including title page, table of contents, report numbering and headings.  The writing style should be clear, correct and professional.

Make sure you have written your name on each page of your submission before attaching the cover sheet and submitting to your teacher/assessor for marking


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.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 5 pages

Cite This Work

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

My Assignment Help. (2020). Information Technology. Retrieved from

My Assignment Help (2020) Information Technology [Online]. Available from:
[Accessed 17 August 2022].

My Assignment Help. 'Information Technology' (My Assignment Help, 2020) <> accessed 17 August 2022.

My Assignment Help. Information Technology [Internet]. My Assignment Help. 2020 [cited 17 August 2022]. Available from:

We Can Help!

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


Other Samples

Content Removal Request

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


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!

callback request mobile
Have any Query?