Databases代做、代写SQL设计编程

日期：2025-02-17 08:30

Databases for Management

Information Systems

Assignment 1

AssignmentType:

PercentageofModuleMark:

DueDate:

Title:

TheDevelopmentandroleofDatabaseManagementSystemsaspartoftheDecision-Making

IndividualReport andDBMS

70%

processeswithinanOrganisation

Organisationstoday,small,mediumandlargedependondigitaldatasets aspartoftheirday-to-day

activities. Database Management Systems as a software solution, play a key role in managing

transactional/operationaldata.Suchsystemsholdverylittlevalueiftheyarenotutilised correctlyto

support effective decision making. In this assignment, identify one real-world organisation and

providethefollowingdeliverables forthatorganisation:

1) Introduction

[Textandreferences,1Diagram +AIJournal],[1PDF],[5%]

a. Stateyourorganisationandprovideaclearset of functionalrequirements(s) forits ICT

infrastructure which your assignment will be focusing on e.g. customer support via

chatbots, HR ICT systems to manage the addition of new staff. For your functional

requirements,adecision-makingelementneedstobeembedded. Max5references.

b. Tocompletethissection,useanyAItoolthatyouwish.Writeupmax200wordsinyourAI

JournalonhowyouleveragedanAI tool todeepenyourunderstandingonyourareaof

interest withinyourtargetorganisation.Provideyourtop3AIqueries&responses and

attachattheendofthisintroduction.Usesomeofyour200wordsinyourAIJournalto

commentontheseAIqueries.

2) BackgroundResearch

[Text,diagramandreferences+AIJournal],[1PDF],[15%]

a. For your specific scenario (target organisationand functional requirements) undertake

general background research into the different ICT platforms/solutions which may

interact with your DBMS. Develop one diagram that shows all the components

interconnected, withyourDBMSasthecentralcomponent. Max10references.

b. Tocompletethissection,useanyAItoolthatyouwish.Writeupmax250wordsinyourAI

JournalonhowyouleveragedanAItooltodeepenyourunderstandingontheapplication

ofdifferentICTsolutionswithinyourtargetorganisation.Provideyourtop3AIqueries&

responsesandattachattheendofthisbackground.Usesomeofyour250wordsinyour

AIJournaltocommentontheseAIqueries.

3) EntityRelationshipDiagram(ERD)

[Text,ERD,Video +AIJournal],[1Videoand1PDF],[15%]

a. Develop1ERDusingcrow’sfootnotationwithmax7entities.Allattributes,relationships,

cardinalities,modalitiesneedtobestated.

b. Max 5-minute video(screen capture recording) of you describing your ERD, the logic

behindyourERDandhowyoufoundAIuseful/ornotinhelpingyoutodevelopyourERD.

c. Tocompletethissection,useanyAItoolthatyouwish.Writeupmax300wordsinyourAI

JournalonhowyouleveragedanAItooltodevelopyourERD.Provideyourtop3AIqueries

& responsesandattachat theendof thisERD. Usesomeof your300wordsin yourAI

JournaltocommentontheseAIqueries.

4) DBMSSolution

[MySQLdatabase, Video+AIJournal],[1MySQLdatabase,1Video and1PDF],[45%]

a. UsingMySQLcreateadatabaseanddeveloptheassociatedtables,relationships etc based

onyourERD.

b. Populateyourtableswithdummydata,minimum20rowsofdatapertable.Ifyouwishto

importpubliclyavailabledata,pleasereferencethedatasourcee.g.https://data.cso.ie/

c. ProvideallSQLscriptsinyourPDF(forrepeatingSQLqueriessuchasinsert,onlyonecopy

issufficient foruniqueinserts).

d. Exportyourdatabase(includingtables,structuresanddata).Iwillimportthisdatabasefor

review.

e. Tocompletethissection,useanyAItoolthatyouwish.Writeupmax500wordsinyourAI

JournalonhowyouleveragedanAItooltodeveloptheMySQLdatabase.Provideyourtop

5AIqueries&responsesandattachattheendofthisDBMS.Usesomeofyour500words

inyourAIJournaltocommentontheseAIqueries.

f. Max10-minutevideo(screencapturerecording)ofyoudescribingyourdatabase,thelogic

behindyourSQLqueriesandhowyou foundAIuseful/ornotinhelpingyoutodevelop

yourdatabase. Themoreknowledgeandunderstandingyoucanconveyofyourdatabase

thehigherthemarks.

5) Organisationalreportstosupportdecisionmaking

[Reports,CSVfiles +AIJournal],[3 Video,nCSVfiles and1PDF],[20%]

a. Develop3reportsbasedonthedatawithinyourdatabase.

i. Eachreportwillneedatmax1chart/tableetc.

ii. ExporttherelevantdatafromtablesintoaCSVfiles

iii. ImportthatdataintoMSExceltogenerateyourGraphs

iv. Max 250words per report and highlightits potential has part of an organisational

decision-making process.

v. Eachreportrequiresamax2-minutevideodescribingitsvalueandhowyouleveraged

AItoassistyouinmakingthisreport.

b. Tocompletethissection,useanyAItoolthatyouwish.Writeupmax250wordsinyourAI

JournalonhowyouleveragedanAItooltodevelopthesereports.Provideyourtop3AI

queries&responsesandattachattheendofthissection. Usesomeofyour250wordsin

yourAIJournaltocommentontheseAIqueries.

Requirements

- Maximum2,500 wordsexcludingAIJournal,references and coverpage

- Allexternalsourcesofinformationmustbereferenced (Harvardreferencingstyle).

- Font - TimesNewRomansize12.

- Spacing- 1.15.

- TableofContents.

- FollowtheAssignmentzipfilestructure.Donotalterit.

- Eachvideomustberecordedbyyouwithyourownvoice.

- SubmitonlineviaCanvasandinonesingleZIP.Onlyzipfileswillbeaccepted.

Coverpagetoincludethefollowing:

• ReportTitle.

• StudentName.

• StudentNumber.

• CourseCode.

• LecturerName

• Module Code .

.

Databases for Management

Information Systems

Assignment 1

Guide Description

Fail Verypoor,clearlyinadequatecoverageofmaterial,badlyprepared,poorqualityand

confusing.Lackofunderstandingas tohoworganisationsfunctionandtheneedfor

databases.AIwasnotusedeffectively.Verylimitedsupportinglogic orreferences.

Pass Acleartargetorganisationwasprovided and arationalfordatabaseswasgiven.

However,nocriticalanalysisof howdecisionmakingmaybeenhancedwasprovided.A

basiccoverageofthesubjectarea,verybasicMySQLdatabase withalimitedsetof

supportingreferences andvideos.

3H Acleartargetorganisationwasprovided and arationalfordatabaseswasgiven with

supportingdecisionmakingrational. AIwasusedbutatabasiclevel,limitedcritical

thinkingandsupportingreferences,thevideosdidnotconveyaveryhighlevelof

understanding. VerybasicMySQLsolutionprovidedwithlimitedvaluereports.

2H2 Aclearsetting withfunctionalrequirementsanddecisionmakinghavebeen clearly

explained.ReasonableanalysisintheusageofAI.TheMySQLdatabaseisdevelopedtoa

goodstandardbutlimitedusageofSQLkeyfunctions.AIwasusedalsoatagoodlevel

butdidnotcriticallyassesstheirusageofAIintheAIjournal.

2H1 Clearexpositionofdomainandagoodselectionofreferences.TheAIJournalislogically

constructedanddemonstratesanexcellentusageoftheAItool.TheMySQLdatabaseis

excellentbutlackingthehigherfeatures ofSQLfunctions.The3finalreportscovera

goodspectrumoftopicsbutlackthecontentwhichwouldbeofrealbenefittotheir

targetorganisation.

1H Outstanding.Thoroughcoverageofthesubject matteri.e.ERD,MySQL,AIJournaland

supportingvideosarealllogicallyconstructed.The3finalreportsclearly addrealvalue

tothetargetorganisation.Perceptiveanalysisandassessmentaccompaniedby

interesting/originalideasornewperspectives.Excellentreport.