$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

ICTDBS502 Information Technology

tag 0 Download5 Pages / 1,083 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

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.

DELIVERABLES:

  • 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.
  • DESIGN AND IMPLEMENTATION – 4th June 2018
  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

 

Cite This Work

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

My Assignment Help. (2020). Information Technology. Retrieved from https://myassignmenthelp.com/free-samples/ictdbs502-information-technology/a-program-accessing.html.

My Assignment Help (2020) Information Technology [Online]. Available from: https://myassignmenthelp.com/free-samples/ictdbs502-information-technology/a-program-accessing.html
[Accessed 23 July 2021].

My Assignment Help. 'Information Technology' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/ictdbs502-information-technology/a-program-accessing.html> accessed 23 July 2021.

My Assignment Help. Information Technology [Internet]. My Assignment Help. 2020 [cited 23 July 2021]. Available from: https://myassignmenthelp.com/free-samples/ictdbs502-information-technology/a-program-accessing.html.


Got a problematic term paper to write? Don’t worry for we’ve got your back. Whether you are having a problem understanding the essay topic or using the correct essay format, you will always get the necessary essay help from us. The materials provided by us will also help you learn how to write a term paper. This way, you can quickly write a superior-quality term paper the next time you have been assigned the task. Contact us today for help with your essay outline and essay editing services.

Latest Other Samples

PM302 Project

Download : 0 | Pages : 35

Answer: The frontline staff of police sector in the UK. In England, a fall of 8% was seen and 6% and 5% fall was seen in Humberside and South Yorkshire respectively.  There were several reasons found behind this fall. One of them was stress and pressure of the officers.  In the views of Smith (2015), the budget cuts are made in the office roles of frontline police staff. This is the reason why there has been a fall in the total numbe...

Read More arrow

C19RH Business Research Methods

Download : 0 | Pages : 6

Answer: Will focus on discussing how and why the human resource is important in retail so as to enhance the knowledge regarding the topic of the dissertation Theoretical body of knowledge used  Human resource is crucial and this dissertation has been initiated with a motive to develop the knowledge regarding the importance of HR and reasons behind the importance of human resource in the retail industry (Reddy & Chandra, 2011). Human...

Read More arrow

MBA505 Business Psychology Coaching And Mentoring

Download : 0 | Page : 1

Answer: Path goal theory: The model of “path goal theory” describes the goal which helps the entrepreneur to achieve the chain market business within 2020 in supermarket (Phillips and Phillips 2016) · After completing the course of MBA, I want to be the Human Resource manager of a modern company.· I have set my aim to be a manager in the Human Resource department in a reputed business organisation, which is in Australi...

Read More arrow Tags: Australia Cowandilla Management Business Psychology  Coaching and Mentoring University of Queensland MBA 

COIT 20246 Internet Of Things

Download : 0 | Pages : 8

Answer: This article describes about one particular individual, who played an important role in the development of modern computing architecture, artificial intelligence. I chose this article as it states about the father of artificial intelligence, John McCarthy. He was the person behind the development of Artificial Intelligence. In this article, the author describes about the role of John McCarthy in the field of Artificial Intelligence. T...

Read More arrow

ITC 568 Cloud Privacy And Security

Download : 0 | Pages : 25

Answer: Management of personal information Personal information is defined in the Privacy Act 1988 as: “...information or an opinion (including information or an opinion forming part of a database), whether true or not, and whether recorded in a material form or not, about an individual whose identity is apparent, or can reasonably be ascertained, from the information or opinion. Management of personal information is an important proce...

Read More arrow
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?