Unit 4: Database Design & Development – China Telecom Limited Helpdesk Systems-ISMT

INTERNATIONAL SCHOOL OF MANAGEMENT AND TECHNOLOGY
NEPAL word image 298 1

FACULTY OF COMPUTING

UNIT TITLE

Unit 4: Database Design & Development

UNIT CODE

A/618/7400

LEVEL

4 (Core)

STUDENT NAME

  

CREDIT VALUE

15

ASSESSMENT TITLE

China Telecom Limited Helpdesk Systems

WORD COUNT

  

ASSESSOR

Bikul Raj Koirala

I.V.

  

ASSIGNMENT ISSUE DATE

9/02/2024

ASSIGNMENT SUBMISSION DATE

9/04/2024

ORIGINAL SUBMISSION

  

ASSIGNMENT NO.

1/1

ASSESSMENT CRITERIA TO BE ASSESSED IN THIS ASSIGNMENT
(Identify all criteria to be assessed in this assignment)

Assignment Criteria

P1

P2

P3

P4

P5

          

Achieved

                  
 

Merit Criteria

Distinction Criteria

Assignment Criteria

M1

M2

M3

M3

M4

M5

D1

D2

D3

  

Achieved

                    

Important:

  • Read the plagiarism notice and requirements at Page 6
  • Word-limit- 8000 words (excludes cover page, table of content, figures, graphs, reference list, appendix and logbook)
  • Accepted Sources: Research Papers(Journal Articles, Conference Proceedings, Thesis), Text Books, Governmental Data, Websites (only a registered organization, an educational institution, government agency)
  • Information taken from unreliable sources will not be accepted
  • Must follow Harvard Reference Style
  • Assignment must be submitted through the Plagiarism Detection Tool

Assignment submission format

Each student has to submit their assignment as guided in the assignment brief. The students are guided on what sort of information is to produce to meet the criteria targeted. You are required to make use of headings, paragraphs, and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system.

Learning outcomes covered
  • LO1 Use an appropriate design tool to design a relational database system for a substantial problem
  • LO2 Develop a fully-functional relational database system, based on an existing system design
  • LO3 Test the system against user and system requirements
  • LO4 Produce technical and user documentation.

Scenario

China Telecom Limited is an ISP company that specializes in Internet and TV service including data storage. China is planning to expand its services introducing Fiber Optics Internet or commonly known as FTTH internet service. Owing to further expansion, China fears that there could be disruption in their services leading to customer dissatisfaction if issues are not answered quickly. The company believes it is essential to build a future-proof infrastructure to ensure that they are able to provide the best-in-class quality of service to their customers. With an aim to increase the customers and also to boost the customer service quality it is setting up an IT Helpdesk to handle customer queries smoothly committed to win customers for life by serving them effectively.

As a Database Developer, you have been tasked with designing and building the new system. Your role includes designing, developing and implementing database systems based on customer requirements. You are also responsible for optimizing the database system for performance efficiency, as well as testing and troubleshooting and performing bug fixes.

System Required

When someone in the company has a problem, they can contact the helpdesk. One of the helpdesk operators will attempt to deal with the enquiry, but if an immediate answer cannot be given the problem is passed to one of several specialists.

An Information System is needed to log and track the helpdesk queries. This will enable analysts to see how the equipment is performing overall, whether the helpdesk specialists are sufficiently resourced to solve problems in an acceptable time and whether there are subject areas where employee training is needed.

Proposed System Operation

  • When a new call comes into the helpdesk, the names of the caller and helpdesk operator are logged, along with the time of the call, the serial number of the computer and, if relevant, the operating system and software being used
  • The caller’s name will be checked against a register of all personnel to retrieve the caller’s ID number, job title and department
  • Their equipment will also be checked against a register of equipment to find the equipment type and make. Their software will be checked to see if it is under a valid license
  • Every call is logged and each problem is given a problem number, which is supplied to the caller so it can be quoted on any subsequent calls about the same problem
  • The helpdesk operator will also record notes and descriptions of the problem. A reason for each call is always recorded even if it is just a note to say how desperate the caller is getting (e.g. in the case of a follow-up call)
  • When a problem is first reported, the helpdesk operator will also allocate a problem type, selecting it from a list of problem types. It is the skill of the operator to know what problem type is most relevant and how specific the problem is
  • Some problem types are refinements of more general problem types and so it is possible that the problem type allocation may be altered later if more information becomes available
  • When the problem area is identified the helpdesk operator can look up previous problems of the same type to see if the problem has occurred before and, if so, how it was resolved
  • It is also possible to look up previous problems with the same equipment or from the same caller to see if there were other related problems
  • If the problem can’t be solved immediately, the helpdesk operator will use the system to look up which specialist to refer the problem to
  • Each specialist will be an expert in one or more problem types
  • If there is no specialist listed for a more specific problem type, then a specialist from the more general problem type will be used
  • The system will also list how many problems the specialist is currently working on so that if there is more than one specialist for a problem type, the specialist who is currently the least loaded can be allocated
  • When a problem is eventually resolved, the helpdesk operator or the specialist will log the date and time it is resolved and record some indication of how the problem was resolved and the time taken to resolve the problem.

ASSIGNMENT TASKS

Task

Activity 1: Designing the Database as per the scenario

Before you start the development process, you need to prepare a proposal document to be submitted to your manager. The document should contain:

1. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables.

2. Clear statements of user and system requirements.

You would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include interface and output designs, data validations and cover data normalization.

Your manager would like a separate report on your assessment of the effectiveness of the design in relation to user and system requirements.

Activity 2: Development and testing of the database system

Create and fully implement the database system showing evidence of user interface, output and data validations and querying across multiple tables using a query language. The system must also be fully secure and maintainable.

Include code snippets and screenshots of the system functionalities as evidence wherever required.

For a higher grade:

You would want to include more than just the basics so you will implement a fully functional database system which will include system security and database maintenance features.

Further provide a detailed assessment of whether meaningful data has been extracted through the use of query tools to produce appropriate management information. and an evaluation of the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.

Further,

Develop and action a test planwith effective tests that includes effective data, and extreme and erroneous data in order to build an accurate picture of the viability of the database

Tests must assess the breadth and usability of the programme as well as the requirements in the brief

Tests must include meaningful data and elements that would demonstrate a successful implementation

Further Produce a written report:

To assess the effectiveness of testing, including an explanation of the choice of the test data used. and evaluate the effectiveness of the database against user requirements and suggest improvements.

5) Produce a series of user videos and a detailed technical and user documentation:

  • Technical: showing the backend of the system and its associated setup, including data flow diagrams and flowcharts, describing how the system works
  • User: showcasing the system from a user perspective.

For a higher grade, You would want to provide some graphical representations for ease of reference in the technical guide, so you need to produce technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works.

Lastly, Evaluate the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.

LEARNING OUTCOMES AND ASSESSMENT CRITERIA

Pass

Merit

Distinction

LO1 Use an appropriate design tool to design a relational database system for a substantial problem

LO1

D1Evaluate the effectiveness of the design in relation to user and system requirements.

P1 Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements.

M1Produce a comprehensive design for a fully-functional system, which includes interface and output designs, data validations and data normalisation

LO2 Develop a fully-functional relational database system, based on an existing system design

LO2 & LO3

D2 Evaluate the effectiveness of the database solution in relation to user and system requirements and suggest improvements.

P2 Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables.

P3 Implement a query language into the relational database system.

M2 Implement a fully functional database system, which includes system security and database maintenance.

M3 Assess whether meaningful data has been extracted through the use of query tools to produce appropriate management information.

LO3 Test the system against user and system requirements

P4 Test the system against user and system requirements.

M4 Assess the effectiveness of the testing, including an explanation of the choice of test data used.

LO4 Produce technical and user documentation

LO4

D3Evaluate the database in terms of improvements needed to ensure the continued effectiveness of the system

P5 Produce technical and user documentation.

M5Produce technical and user documentation for a fully-functional system, including data flow diagrams and flowcharts, describing how the system works.

Plagiarism Notice

You are reminded that there exist Academic Misconduct Policy and Regulation concerning Cheating and Plagiarism.

Extracts from the Policy:

Section 3.4.1: Allowing others to do assignments / Copying others assignment is an offence

Section 3.4.2: Plagiarism, using the views, opinion or insights / paraphrasing of another person’s original phraseology without acknowledgement

Requirements

  • It should be the student’s own work – Plagiarism is unacceptable.
  • Clarity of expression and structure are important features.
  • Your work should be submitted as a well presented, word-processed document with headers and footers, and headings and subheadings.
  • You are expected to undertake research on this subject using books from the Library, and resources available on the Internet.
  • Any sources of information should be listed as references at the end of your document and these sources should be referenced within the text of your document using Harvard Referencing style
  • Your report should be illustrated with screen-prints, images, tables, charts and/or graphics.
  • All assignments must be typed in Times New Roman, font size 12, 1.5 spacing.
  • The center policy is that you must submit your work within due date to achieve “Merit” and “Distinction”. Late submission automatically eliminates your chance of achieving “Merit and Distinction”. Also, 80% attendance is required to validate this assignment.

Assignment Prepared By

 

Signature

Date

3/10/2023

Brief Checked By

 

Signature

 

Date

3/10/2023

662 Comments

  3. Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?

  11. calcipotriol sans ordonnance [url=https://pharmacieexpress.com/#]cicaplast baume levre[/url] vente de viagra

  15. dapoxetina farmacia online [url=http://confiapharma.com/#]farmacia veterinaria venta online[/url] comprar rybelsus espaГ±a sin receta

  22. la buscapina se puede comprar sin receta [url=https://confiapharma.shop/#]comprar mentis sin receta[/url] farmacia moldova online

  26. farmacia ariston napoli [url=http://farmaciasubito.com/#]protopic unguento[/url] farmacia online consegna 24 ore

  32. tadap 20 mg prezzo [url=https://farmaciasubito.shop/#]lyrica 75 prezzo con ricetta[/url] farmacia online spedizione veloce

  36. ribavirin online pharmacy [url=http://pharmexpress24.com/#]online pharmacy us[/url] caremark specialty pharmacy

  39. is mexicanrxpharm legit [url=https://pharmmex.shop/#]farmacia mexicana[/url] mexican pharmacy in los angeles

  43. buy medication from india [url=http://inpharm24.com/#]InPharm24[/url] b pharmacy salary in india

  51. order from mexican pharmacy [url=https://pharmmex.shop/#]mexican pharmacy hydrocodone[/url] can you buy ivermectin in mexico

  53. kamagra uk online pharmacy [url=https://pharmexpress24.com/#]Pharm Express 24[/url] turkey pharmacy online

  62. buying from online mexican pharmacy [url=https://medsfrommexico.com/#]Meds From Mexico[/url] mexican online pharmacies prescription drugs

  68. cheapest pharmacy canada [url=https://canadapharmglobal.shop/#]canada pharmacy online legit[/url] canadian mail order pharmacy

  72. Online medicine home delivery [url=http://indiapharmglobal.com/#]India Pharm Global[/url] best india pharmacy

  76. indian pharmacies safe [url=https://indiapharmglobal.shop/#]reputable indian pharmacies[/url] top 10 pharmacies in india

  80. sciroppo augmentin bambini prezzo [url=https://efarmaciait.shop/#]minoxidil max[/url] slowmet recensioni

  104. fast grГёnnsГҐpe apotek [url=https://raskapotek.shop/#]loppemiddel hund apotek[/url] Rask Apotek

  128. ketoconazole online pharmacy [url=http://pharmaconnectusa.com/#]Pharma Connect USA[/url] loratadine pharmacy

  149. dokter online medicijnen bestellen [url=http://medicijnpunt.com/#]MedicijnPunt[/url] betrouwbare online apotheek

  156. pharmacie caen ouverte aujourd’hui [url=https://pharmaconfiance.com/#]Pharma Confiance[/url] Pharma Confiance

  164. prix tadalafil [url=https://pharmaconfiance.shop/#]pharmacie de la fleur strasbourg[/url] protopic 0 1 pharmacie en ligne

  175. mebendazole online pharmacy [url=http://pharmaconnectusa.com/#]Pharma Connect USA[/url] community rx pharmacy warren mi

  192. inhouse pharmacy domperidone [url=https://pharmaconnectusa.shop/#]Pharma Connect USA[/url] xlpharmacy viagra

  197. Pharma Confiance [url=https://pharmaconfiance.com/#]imodium pour chien[/url] pharmacie de garde lourdes aujourd’hui

  205. PharmaConnectUSA [url=https://pharmaconnectusa.shop/#]Pharma Connect USA[/url] online pharmacy cialis

  244. Pharma Connect USA [url=https://pharmaconnectusa.com/#]Pharma Connect USA[/url] PharmaConnectUSA

  248. Pharma Confiance [url=https://pharmaconfiance.shop/#]verveine menthe toulouse[/url] Pharma Confiance

  252. IndiMeds Direct [url=https://indimedsdirect.com/#]buy medicines online in india[/url] india online pharmacy

  256. best online pharmacy india [url=http://indimedsdirect.com/#]IndiMeds Direct[/url] cheapest online pharmacy india

  259. TijuanaMeds [url=https://tijuanameds.com/#]best online pharmacies in mexico[/url] mexican online pharmacies prescription drugs

  261. canadian online pharmacy [url=http://canrxdirect.com/#]CanRx Direct[/url] legal canadian pharmacy online

  264. pharmacy com canada [url=https://canrxdirect.com/#]best canadian pharmacy[/url] canadian pharmacy tampa

  269. enclomiphene price [url=https://enclomiphenebestprice.com/#]enclomiphene for sale[/url] enclomiphene testosterone

  273. Farmacia Asequible [url=http://farmaciaasequible.com/#]п»їfarmacia online[/url] Farmacia Asequible

  286. farmacia on line.com [url=https://farmaciaasequible.shop/#]melatonina 5 mg opiniones[/url] Farmacia Asequible

  290. farmacias abiertas en vigo [url=https://farmaciaasequible.com/#]casenlax opiniones[/url] Farmacia Asequible

  294. enclomiphene best price [url=http://enclomiphenebestprice.com/#]buy enclomiphene online[/url] enclomiphene buy

  310. enclomiphene online [url=https://enclomiphenebestprice.shop/#]enclomiphene testosterone[/url] enclomiphene testosterone

  314. online pharmacy reviews percocet [url=https://rxfreemeds.com/#]RxFree Meds[/url] how much is cialis at the pharmacy

  319. buy enclomiphene online [url=https://enclomiphenebestprice.shop/#]buy enclomiphene online[/url] enclomiphene for men

  328. Farmacia Asequible [url=https://farmaciaasequible.com/#]Farmacia Asequible[/url] Farmacia Asequible

  331. RxFree Meds [url=http://rxfreemeds.com/#]online pharmacy sildenafil citrate[/url] ondansetron online pharmacy

  336. enclomiphene testosterone [url=https://enclomiphenebestprice.com/#]enclomiphene best price[/url] enclomiphene citrate

  349. Farmacia Asequible [url=http://farmaciaasequible.com/#]melatonina 5 mg farmacia espaГ±a[/url] farmacias en gibraltar

  353. Farmacia Asequible [url=http://farmaciaasequible.com/#]diprogenta crema precio espaГ±a[/url] Farmacia Asequible

  356. farmacias 24 horas alicante [url=https://farmaciaasequible.com/#]Farmacia Asequible[/url] Farmacia Asequible

  364. micostatin para que sirve [url=http://farmaciaasequible.com/#]Farmacia Asequible[/url] para que sirve el movicol

  369. enclomiphene best price [url=https://enclomiphenebestprice.shop/#]enclomiphene[/url] buy enclomiphene online

  375. enclomiphene best price [url=https://enclomiphenebestprice.shop/#]enclomiphene price[/url] enclomiphene online

  379. enclomiphene [url=https://enclomiphenebestprice.com/#]enclomiphene online[/url] enclomiphene buy

  382. enclomiphene for sale [url=https://enclomiphenebestprice.com/#]enclomiphene buy[/url] enclomiphene online

  391. MexiMeds Express [url=https://meximedsexpress.shop/#]MexiMeds Express[/url] mexican mail order pharmacies

  408. mexican drugstore online [url=http://meximedsexpress.com/#]MexiMeds Express[/url] mexico drug stores pharmacies

  414. MexiMeds Express [url=https://meximedsexpress.shop/#]MexiMeds Express[/url] mexico drug stores pharmacies

  418. online pharmacy baclofen [url=http://medismartpharmacy.com/#]MediSmart Pharmacy[/url] online pharmacy generic seroquel

  427. pharmacy rx solutions [url=http://medismartpharmacy.com/#]express rx pharmacy[/url] ez online pharmacy viagra

  432. effexor xr online pharmacy [url=http://medismartpharmacy.com/#]MediSmart Pharmacy[/url] asda pharmacy ventolin inhaler

  435. target pharmacy lexapro [url=http://medismartpharmacy.com/#]anti fungal[/url] is online pharmacy legit

  438. online pharmacy europe [url=https://medismartpharmacy.shop/#]MediSmart Pharmacy[/url] viagra discount pharmacy

  449. baclofen pharmacy [url=https://medismartpharmacy.shop/#]is reliable rx pharmacy legit[/url] wal mart pharmacy prices cialis

  457. farmacia online sin pedido minimo [url=https://clinicagaleno.shop/#]Clinica Galeno[/url] ansioliticos que se pueden comprar sin receta

  461. farmacia online mascherine [url=https://ordinasalute.com/#]menaderm simplex crema a cosa serve[/url] bronchomunal bambini

  464. comprar orfidal online [url=https://clinicagaleno.shop/#]Clinica Galeno[/url] farmacia online salbutamol

  471. prep farmacia online [url=https://clinicagaleno.shop/#]comprar codeina sin receta espaГ±a[/url] doctorado en farmacia online

  475. pommade antibiotique sans ordonnance [url=http://pharmadirecte.com/#]PharmaDirecte[/url] seretide 500 sans ordonnance

  481. vilken värktablett är bäst för magen [url=http://snabbapoteket.com/#]Snabb Apoteket[/url] apotek blodtryck

  486. bestille medisin pГҐ nett [url=https://tryggmed.shop/#]Гёrerenser apotek[/url] elektrolytt pulver apotek

  489. online medicijnen bestellen met recept [url=https://zorgpakket.shop/#]apotheek recept[/url] online apotheek

  499. dokter online medicijnen bestellen [url=https://zorgpakket.shop/#]MedicijnPunt[/url] internetapotheek spanje

  505. online shopping pharmacy india [url=http://indiamedshub.com/#]IndiaMedsHub[/url] indian pharmacy online

  511. clomid pharmacy [url=https://expresscarerx.org/#]viagra no prescription online pharmacy[/url] ExpressCareRx

  518. cheapest online pharmacy india [url=https://indiamedshub.shop/#]pharmacy website india[/url] india pharmacy

  528. ExpressCareRx [url=https://expresscarerx.online/#]ExpressCareRx[/url] bupropion sr online pharmacy

  532. buy neurontin in mexico [url=https://medimexicorx.com/#]gabapentin mexican pharmacy[/url] MediMexicoRx

  536. where can i buy lexapro online [url=https://lexapro.pro/#]price for lexapro 10 mg[/url] Lexapro for depression online

  540. how much is lexapro in australia [url=https://lexapro.pro/#]Lexapro for depression online[/url] price for lexapro 10 mg

  544. Lexapro for depression online [url=https://lexapro.pro/#]Lexapro for depression online[/url] compare lexapro prices

  558. Finasteride From Canada [url=http://finasteridefromcanada.com/#]Propecia for hair loss online[/url] cheap Propecia Canada

  563. tadalafil from india [url=https://tadalafilfromindia.com/#]generic Cialis from India[/url] Tadalafil From India

  576. cheap Accutane [url=https://isotretinoinfromcanada.com/#]Isotretinoin From Canada[/url] Isotretinoin From Canada

  582. cheap Accutane [url=https://isotretinoinfromcanada.shop/#]buy Accutane online[/url] isotretinoin online

  586. cheap Propecia Canada [url=http://finasteridefromcanada.com/#]Propecia for hair loss online[/url] cheap Propecia Canada

  593. how much is generic lexapro [url=https://lexapro.pro/#]Lexapro for depression online[/url] generic brand for lexapro

  609. anti-inflammatory steroids online [url=https://reliefmedsusa.shop/#]prednisone uk[/url] prednisone 30 mg

  613. Modafinil for focus and productivity [url=https://wakemedsrx.com/#]where to buy Modafinil legally in the US[/url] Modafinil for focus and productivity

  618. buy amoxicillin online cheap [url=https://clearmedsdirect.com/#]order amoxicillin without prescription[/url] amoxicillin 500mg

  622. Modafinil for ADHD and narcolepsy [url=https://wakemedsrx.com/#]prescription-free Modafinil alternatives[/url] order Provigil without prescription

  628. gabapentin neuropathic cancer pain [url=https://neuroreliefrx.shop/#]gabapentin order[/url] neurontin vs generic gabapentin

  633. ClearMeds Direct [url=https://clearmedsdirect.com/#]how to get amoxicillin over the counter[/url] ClearMeds Direct

  641. Clear Meds Direct [url=https://clearmedsdirect.shop/#]amoxicillin order online no prescription[/url] low-cost antibiotics delivered in USA

  644. Wake Meds RX [url=https://wakemedsrx.shop/#]buy Modafinil online USA[/url] nootropic Modafinil shipped to USA

  649. NeuroRelief Rx [url=http://neuroreliefrx.com/#]can you mix gabapentin with percocet[/url] gabapentin 300 mg cap teva

  655. IndiGenix Pharmacy [url=http://indigenixpharm.com/#]buy medicines online in india[/url] IndiGenix Pharmacy

Leave a Reply

Your email address will not be published. Required fields are marked *