Databases for ManagementInformation Systems

Databases for ManagementInformation Systems

Assignment 1Assignment Type:Percentage of Module Mark:

Due Date:

Title:

The Development and role of Database Management Systems as part of the Decision-MakingIndividual Report and DBMS70%processes within an OrganisationOrganisations today, small, medium and large depend on digital datasets as part of their day-to-dayactivities. Database Management Systems as a software solution, play a key role in managingtransactional/operational data. Such systems hold very little value if they are not utilised correctly to

support effective decision making. In this assignment, identify one real-world organisation andprovide the following deliverables for that organisation:

1. 1) Introduction[Text and references, 1 Diagram + AI Journal], [1 PDF], [5%]

1. State your organisation and provide a clear set of functional requirements(s) for its ICTinfrastructure which your assignment will be focusing on e.g. customer support viachatbots, HR ICT systems to manage the addition of new staff. For your functionalrequirements, a decision-making element needs to be embedded. Max 5 references.

1. To complete this section, use any AI tool that you wish. Write up max 200 words in your AIJournal on how you leveraged an AI tool to deepen your understanding on your area ofinterest within your target organisation. Provide your top 3 AI queries & responses andattach at the end of this introduction. Use some of your 200 words in your AI Journal tocomment on these AI queries.2) Background Research[Text, diagram and references + AI Journal], [1 PDF], [15%]For your specific scenario (target organisation and functional requirements) undertakegeneral background research into the different ICT platforms/solutions which mainteract with your DBMS. Develop one diagram that shows all the componentsinterconnected, with your DBMS as the central component. Max 10 references.

1. To complete this section, use any AI tool that you wish. Write up max 250 words in your AI

Journal on how you leveraged an AI tool to deepen your understanding on the applicationof different ICT solutions within your target organisation. Provide your top 3 AI queries &

esponses and attach at the end of this background. Use some of your 250 words in yourAI Journal to comment on these AI queries.

3. 3) Entity Relationship Diagram (ERD)[Text, ERD, Video + AI Journal], [1 Video and 1 PDF], [15%]

1. Develop 1 ERD using crow’s foot notation with max 7 entities. All attributes, relationshipscardinalities, modalities need to be stated.

1. Max 5-minute video (screen capture recording) of you describing your ERD, the logicehind your ERD and how you found AI useful/or not in helping you to develop your ERD.

To complete this section, use any AI tool that 代 写Databases for ManagementInformation Systems  you wish. Write up max 300 words in your AIournal on how you leveraged an AI tool to develop your ERD. Provide your top 3 AI querie& responses and attach at the end of this ERD. Use some of your 300 words in your AIJournal to comment on these AI queries.

4. 4) DBMS Solution[MySQL database, Video + AI Journal], [1 MySQL database, 1 Video and 1 PDF], [45%]

1. Using MySQL create a database and develop the associated tables, relationships etc basedon your ERD.

1. Populate your tables with dummy data, minimum 20 rows of data per table. If you wish tomport publicly available data, please reference the data source e.g. https://data.cso.ie/

1. Provide all SQL scripts in your PDF (for repeating SQL queries such as insert, only one copyis sufficient for unique inserts).

1. Export your database (including tables, structures and data). I will import this database for

eview.

1. To complete this section, use any AI tool that you wish. Write up max 500 words in your AIJournal on how you leveraged an AI tool to develop the MySQL database. Provide your top5 AI queries & responses and attach at the end of this DBMS. Use some of your 500 wordsin your AI Journal to comment on these AI queries.

1. Max 10-minute video (screen capture recording) of you describing your database, the logicbehind your SQL queries and how you found AI useful/or not in helping you to developyour database. The more knowledge and understanding you canconvey of your databasethe higher the marks.5) Organisational reports to support decision making[Reports, CSV files + AI Journal], [3 Video, n CSV files and 1 PDF], [20%]Develop 3 reports based on the data within your database.

1. Each report will need at max 1 chart/table etc.
2. Export the relevant data from tables into a CSV files
3. Import that data into MS Excel to generate your Graphs
4. Max 250 words per report and highlight its potential has part of an organisationaldecision-making process.

1. Each report requires a max 2-minute video describing its value and how you leveragedAI to assist you in making this report.

1. To complete this section, use any AI tool that you wish. Write up max 250 words in your AIJournal on how you leveraged an AI tool to develop these reports. Provide your top 3 AIqueries & responses and attach at the end of this section. Use some of your 250 words inyour AI Journal to comment on these AI queries.

Requirements

- Maximum 2,500 words excluding AI Journal, references and cover page

- All external sources of information must be referenced (Harvard referencing style).

- Font - Times New Roman size 12.

- Spacing- 1.15.

- Table of Contents.

- Follow the Assignment zip file structure. Do not alter it.

- Each video must be recorded by you with your own voice.

- Submit online via Canvas and in one single ZIP. Only zip files will be accepted.Cover page to include the following:

• Report Title.
• Student Name.
• Student Number.
• Course Code.
• Lecturer Name
• Module Code .

.Databases for ManagementInformation Systems

Assignment 1GuideDescriptionFaiVery poor, clearly inadequate coverage of material, badly prepared, poor quality andconfusing. Lack of understanding as to how organisations function and the need fordatabases. AI was not used effectively. Very limited supporting logic or references.

PassA clear target organisation was provided and a rational for databases was given.However, no critical analysis of how decision making may be enhanced was provided. Abasic coverage of the subject area, very basic MySQL database with a limited set ofsupporting references and videos.3H

A clear target organisation was provided and a rational for databases was given withsupporting decision making rational. AI was used but at a basic level, limited critical

thinking and supporting references, the videos did not convey a very high level of

understanding. Very basic MySQL solution provided with limited value reports.2H2A clear setting with functional requirements and decision making have been clearly

xplained. Reasonable analysis in the usage of AI. The MySQL database is developed to agood standard but limited usage of SQL key functions. AI was used also at a good levelbut did not critically assess their usage of AI in the AI journal.2H1Clear exposition of domain and a good selection of references. The AI Journal is logicallyconstructed and demonstrates an excellent usage of the AI tool. The MySQL database isexcellent but lacking the higher features of SQL functions. The 3 final reports cover agood spectrum of topics but lack the content which would be of real benefit to theirtarget organisation.1HOutstanding. Thorough coverage of the subject matter i.e. ERD, MySQL, AI Journal andsupporting videos are all logically constructed. The 3 final reports clearly add real valueto the target organisation. Perceptive analysis and assessment accompanied byinteresting/original ideas or new perspectives. Excellent report.