Database Technologies

Assignment Description
Part A: (20 marks)
Paste below the summary of your Assignment 2 online quiz on Moodle. The quiz will be open in week 9 laboratory class.
Part B: (70 marks)

  1. Database Design
    Assume that you are the database developer for this task, complete the information-level design for the new database for “MIT_short_courses” that satisfies the constraints and user view requirements given below. Create a Crow’s Foot Notation Entity Relationship Diagram (ERD) to support the following business operations. MIT is planning to design a data model to hold information relating to their Courses, Students, Coordinators, Instructors and Classes. User requirement / business rule 1:
     As a database designer for “MIT_short_courses”, you need to ensure that each student can register for one or more short courses.
     You need to store students’ details including students ID, first name, last name, gender, age, and postal code.
    User requirement / business rule 2:
     Each course has one Coordinator assigned to look after general administration of the course. However, each Coordinator may be assigned to one or more courses.
     System stores Coordinator’s code, name and the school he/she attached to.
     Each course offers zero or more classes. Some courses are research based they do not offer classes.
     Each Course has an ID (for unique identification), title, credits and prerequisites.
    User requirement / business rule 3:
     Each class has an ID, Section no, Date and Time.
     Each class is taught by an instructor.
     Instructors can teach in one or more scheduled classes. However, some Instructors are working with research students therefore no classes allocated to them in the system.
    Write down any assumptions you have made, if they are not explicitly described here.
    While completing the information-level design you are required to answer questions given below.
    a. Identify and list entities described in the given case scenario. (5 Marks)
    b. ER diagram
    Add attributes to those entities and select suitable primary keys for each entity.
    Represent the structure of your database visually by using the entity-relationship (ER) diagram.
    I. You are required to mark all cardinality on the relationships. if you make any assumptions (When you mark cardinality) about data that are not explicitly given in the problem, these must be described. (5 Marks)
    II. You are required to use a software tool to create the ER diagram. You can use draw.io[2], Lucidchart [1], Visio or any other software tool to create the ER diagram.
    Note: All many to many relationships must be replaced with bridge tables. (20 Marks)
  2. Data Integrity
    In this question you will transform an entity-relationship (ER) Diagram into a relational schema (data model) yoy need to ensure that the resulting relations are in 3NF.
    a. First, represent entities and attributes as collection of tables and attributes.
    Eg. Student (Stu_ID, Sname,…….
    NB: Select suitable primary key for each table and underline them. (5 Marks)
    b. Determine the functional dependences. (5 Marks)
    Eg. Stu_ID — > Sname, , ……, ……
    c. Normalise these tables. Make the normalization to 3NF and explain every step in the process. (10 Marks)
  3. Model Building
     Build this model using MS Access/SQLite by creating these tables and Relationships.
     Populate these tables with appropriate data, at least 2 records in each table.
     Include following into your MS Word document. (10 Marks)
    I. If you are using MS Access include following screen shots
     Relationship diagram created in Access. (Select database tools Relationships in the Access menu)
     Data sheet view and design view of your tables as given below in Figure 1 and 2. For Student_Name and Student_ID you need to use your MIT ID and your name as one data record.
    Figure 1 Data Sheet View Figure 2 Design View
    II. If you are using SQLite
     Include screen shots of CREATE TABLE command and INSERT INTO commands.
  4. Report Generation
    a. Write a query to extract useful information from this “MIT_short_courses”, database.(3 Marks)
    b. Execute this query on the database and attach the screenshot of your output. (2 Marks)
  5. Research Question
    MongoDB is a popular general purpose database platform. Write a brief description about this database by comparing the features in MS Access.
    Answer with at least 150 words using suitable citations and references for the materials you used for this work. Use IEEE reference style.
Order Now
No Fields Found.
Universal Assignment (February 16, 2026) Database Technologies. Retrieved from https://universalassignment.com/database-technologies/.
"Database Technologies." Universal Assignment - February 16, 2026, https://universalassignment.com/database-technologies/
Universal Assignment June 18, 2022 Database Technologies., viewed February 16, 2026,<https://universalassignment.com/database-technologies/>
Universal Assignment - Database Technologies. [Internet]. [Accessed February 16, 2026]. Available from: https://universalassignment.com/database-technologies/
"Database Technologies." Universal Assignment - Accessed February 16, 2026. https://universalassignment.com/database-technologies/
"Database Technologies." Universal Assignment [Online]. Available: https://universalassignment.com/database-technologies/. [Accessed: February 16, 2026]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

Assignment SHSM024 RESEARCH DESIGN & DATA REPORT

ANSWER FORM ETHICS: (approx. 300 words in total) 10 OBTAINING CONSENT: Describe the process that the researchers would have to implement to obtain consent for a pregnant woman to participate in the study. OBTAINING ETHICAL APPROVAL: Describe two other areas of the study procedures (not including ‘obtaining consent’) that a

Read More »

Assignment Brief Sheet

Assignment Brief Sheet1Module Tutor:Dr Dennis PeppleModule NameStudy Skills and Personal Development PlanningModule CodeCBU401Title of Coursework:Assessment 1: Written Assignment (1500 words)Weight: 50%Title of Coursework:Assessment 2: Reflective (PDP) Report (1500 words)Weight: 50%Feedback detailsThe university policy is that you will receive prompt feedback on your work within 2 weeks of the submission date.

Read More »

Assignment Faculty of Business, Computing and Digital Industries

Module Handbook Faculty of Business, Computing and Digital Industries School of Business (On-campus) E-Business and E-Marketing Module. 2025-26 Contents Module Introduction Module Leader Welcome Hello A very warm welcome to the E-Business and E-Marketing module. I hope that you find this Module Handbook helpful in supporting your studies and that

Read More »

Assignment Brief BMM6422: Business and Management Strategies

Assignment Brief BMM6422: Business and Management StrategiesComponent numberAssignment 1Assignment typeReportLearning outcomes for this assessment(Please see module Handbook for all learning outcomes)Upon completion of this module students should be able to:1 Evaluate the benefits to organisations of strategic planning within the business environment.2 Employ specific techniques, methods and models used in

Read More »

ASSIGNMENT Business and Management Strategy

Module Handbook Faculty of Business, Computing and Digital Industries School of Business (On-campus) Business and Management Strategy BMM6422 2025-26 Contents Module Introduction Module Leader Welcome Welcome to Business and Management Strategy Hello I hope that you find this Module Handbook helpful in supporting your studies and that it provides you

Read More »

BMM6302 Entrepreneurship and Creativity 

Assignment Brief – Cohort 06 BMM6302 Entrepreneurship and Creativity  Component number Assignment 2 Assignment type 02 Dragon’s Den Presentation (Live Presentation) Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare and contrast a variety of strategic models to develop and critically evaluate business start-up ideas.

Read More »

BMM6302 Entrepreneurship and Creativity 

Assignment Brief – Cohort 07 BMM6302 Entrepreneurship and Creativity  Component number Assignment 1 Assignment type 01 Business Idea (Video Presentation – Panopto) Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare and contrast a variety of strategic models to develop and critically evaluate business start-up

Read More »

LCRM301 Researching Criminology

LCRM301 Researching CriminologyTopic: Introduction to theoryand the research processand undertaking acriminological literaturereviewAcknowledgement ofcountryPART ONE: Preparingcriminological research(Weeks 1-5)In the first part of the unit, we focus on preparing criminologicalresearch and decision-making processes. This includes deciding onthe topic you want to focus on, the kinds of methods to use and thetypes of

Read More »

LCRM301 Researching criminology

LCRM301 Researching criminologyWorksheet 1This worksheet will be disseminated to students in Week 3 and will assist them in the planning and development of the second assessment task: literature review. PART 1: Refining your topicThe topic I am interested in is: I am interested in this topic because: This is an

Read More »

LCRM301 Researching Criminology

LCRM301 Researching CriminologyTopic: Planningcriminological research andformulating effectiveresearch questionsAcknowledgement ofcountryLecture structure Example?How do police perceptions of their own organization influence their views of the public,specifically their trust of people in the areas they patrol?How do women with insecure migration status experience and seek help for family violenceand what are their experiences

Read More »

ASSESSMENT NO.2 – COURT APPLICATION FACT PATTERN

FACULTY OF LAW AND BUSINESSThomas More Law SchoolLAWS201: CIVIL PROCEDURE & ADRSEMESTER TWO, 2025 – NATIONAL –ASSESSMENT NO.2 – COURT APPLICATION FACT PATTERN(AND THE FACT PATTERN FOR THE PLEADINGS WORKSHOP IN WEEK 5)BackgroundRachel Richardson is a printer by trade although she currently works in art design fora fashion magazine based

Read More »

Assessment 2: Court Application

02/09/2025, 20:3430 Points PossibleAssessment 2: Court ApplicationAssessment 2: Court ApplicationDetailsAssessment task 2: Court Application (worth 30% of the final total mark for this unit)Add commentA simulated court application will be run in weeks 6 and 7 of semester on selected topics from the first five weeks of the unit. Your

Read More »

APPENDIX B: ASSESSMENT TASK 2 – COURT APPLICATION

APPENDIX B: ASSESSMENT TASK 2 – COURT APPLICATION (30% OF FINAL MARK)General informationThis Assessment task is worth 30 marks of your final mark.The task is either making (Applicant) or opposing (Respondent) an application before theSupreme Court in your respective state based on a fact scenario, which will be uploaded on

Read More »

Assessment task Assessment 1 – ASSIGNMENT

Assessment Task 1 (30% of the final mark)This Week30 Points PossibleIn ProgressNEXT UP: Submit assignmentUnlimited Attempts Allowed11/08/2025Attempt 1 Add commentDetails Assessment task Assessment 1 – ASSIGNMENTPurpose To give students the opportunity to produce a well-written piece of formal analysis on a topic inland law. Graduate capabilities GC1,3,7-11 are covered by

Read More »

Assessment Brief- Assessment 3- Map-Reduce Programming Challenge

Assessment Brief- Assessment 3- Map-Reduce Programming Challenge Unit Code/Description ICT313 Big Data for Software DevelopmentCourse/Subject Bachelor of Information TechnologySemester S1 – 2025Unit Learning OutcomesAddressedULO3: Critically assess and implement advanced data pre-processing andanalytics strategies in a software development context, focusing on tasks like datacleansing, transformation, and feature selection.ULO4: Design, develop, and

Read More »

Assessment 2 Infographic and Reflection

Assessment 2 Infographic and Reflection Part 1 Infographic and Part 2 Reflection using the Gibbs CycleThis assessment is worth 35% of your final grade (Infographic 18% + Reflection 17%). Assessment InstructionsPart 1: InfographicCreate an A3 size infographic (portrait layout).Submit as a .pdfTOPIC:Create your infographic as a poster (A3 paper size)

Read More »

CHCCSM013 Facilitate and review case management

ContentsAbout this document 4Student details section 4The community services work environment 5Workplace hours 6Responsibilities 6Evidence collection 7Section 1: Determine response for case management 9Section 2: Conduct case management meetings and develop case management plan 18Section 3: Monitor and review case work activities and processes 24Section 4: Supervisor report 28 About

Read More »

BMM6302 Entrepreneurship and Creativity Assignment help

Assignment Brief – Cohort 07 BMM6302 Entrepreneurship and Creativity  Component number Assignment 1 Assignment type 01 Business Idea (Video Presentation – Panopto) Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare and contrast a variety of strategic models to develop and critically evaluate business start-up

Read More »

BMM6582: eBusiness and eMarketing 02 Analytical Review Assignment Help

Assignment Brief BMM6582: eBusiness and eMarketing Component number Assignment 2 Assignment type 02 Analytical Review Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare, contrast, and analyse approaches used to evaluate a company’s current positioning in the traditional and electronic marketplaces. Appraise various options for

Read More »

BMM6582: eBusiness and eMarketing Assignment 2 Assignment Help

Assignment Brief BMM6582: eBusiness and eMarketing Component number Assignment 2 Assignment type 02 Analytical Review Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare, contrast, and analyse approaches used to evaluate a company’s current positioning in the traditional and electronic marketplaces. Appraise various options for

Read More »

BMM6582: eBusiness and eMarketing Assignment Help

Assignment Brief BMM6582: eBusiness and eMarketing Component number Assignment 1 Assignment type 01 Video presentation (Panopto) Learning outcomes for this assessment (Please see module Handbook for all learning outcomes) Compare, contrast, and analyse approaches used to evaluate a company’s current positioning in the traditional and electronic marketplaces. Appraise various options

Read More »

Business and Management Strategy Assignment Help

Business and Management Strategy: Assignment Guidelines and Suggested Structure (3,000 Words) 1. Introduction (approx. 250–300 words) 2. Industry Analysis and Competitive Environment (400–450 words) 3. Competition and Customer Requirements (550–600 words) 4. Resources and Strategy Implementation (500–550 words) 5. Strategic Capabilities & Sustainable Advantage (400–450 words) 6. Development of Resources

Read More »

BMM6452 – Professional Learning Through Work Assignment Help

Assignment Brief  BMM6452 – Professional Learning Through Work Assignment type  Final Assessment (Assessment 3)-To be Negotiated Learning outcomes   (Please see module Handbook for all learning outcomes)  By the end of this module, the student should be able to:  Demonstrate enhanced graduate employability skills, knowledge, behaviours and attitudes developed through working

Read More »

CSE2/4DBF (2025) – Assignment 1

CSE2/4DBF (2025) – Assignment 1 Page 1/3 CSE2/4DBF 2025Assignment 1 (20%)Due date: this week AIMS AND OBJECTIVES:✓ to represent a problem description given in natural language as an (Enhanced) EntityRelationship modelThis is an individual Assignment. You are not permitted to work as a group when writingthis assignment. The use of

Read More »

Can I Pay Someone to Do My Assignment? A Complete Student Guide

If you’re a student juggling multiple deadlines, exams, part-time work, or personal responsibilities, you may have found yourself asking: can I pay someone to do my assignment? You’re not alone. This is one of the most searched academic questions today, especially among university and college students worldwide. In this blog,

Read More »

Project Development and Analysis in Emerging Technologies

Assessment Brief- Assessment 2 Unit Code/Description ICT305 – Topics in IT Course/Subject BIT Semester 2024- S1 Unit Learning Outcomes Addressed ULO 1, 2, and 3. Assessment Objective The primary objective of this assessment is to provide students with hands-on experience in designing, implementing, and analysing a project in one of

Read More »

EDUC1006 Interdisciplinary Studies: Crossing the line

ASSESSMENT 2: Report Summary Title Assessment 2 Type Report Due Date Thursday 17 April, 11.59 pm (end of Week 6) Length 1500 words or equivalent Weighting 50% Academic Integrity The use of GenAI is allowed but limited for this assessment task. Submission Word document or PDF submitted to Turnitin Unit

Read More »

Writing in Community Development

Assessment Overview Overview Length or Duration Worth Due This essay should demonstrate a coherent argument, which is backed up by evidence from relevant journal articles, books and websites. You are expected to make two direct quotations only; and the rest should be paraphrases. You should also list at least eight sources.   If you are unsure of

Read More »

Can't Find Your Assignment?