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 9, 2023) Database Technologies. Retrieved from https://universalassignment.com/database-technologies/.
"Database Technologies." Universal Assignment - February 9, 2023, https://universalassignment.com/database-technologies/
Universal Assignment June 18, 2022 Database Technologies., viewed February 9, 2023,<https://universalassignment.com/database-technologies/>
Universal Assignment - Database Technologies. [Internet]. [Accessed February 9, 2023]. Available from: https://universalassignment.com/database-technologies/
"Database Technologies." Universal Assignment - Accessed February 9, 2023. https://universalassignment.com/database-technologies/
"Database Technologies." Universal Assignment [Online]. Available: https://universalassignment.com/database-technologies/. [Accessed: February 9, 2023]

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.

Get 90%* Discount on Assignment Help

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

BSBWOR502 – Lead and manage team effectiveness

BSBWOR502 – Lead and manage team effectiveness The BSBWOR502 – Lead and manage team effectiveness is a unit of the resource training. Also, it is competency training that helps aspiring team leaders build the necessary skills. Since team leadership in the workplace requires many abilities, this unit provides an approach

Read More »

BUSN 732 Writing Assignment 2

Description This assignment gives you an opportunity to read, summarize, and analyze material to be presented in a short report. Specifically, you are asked to read the five assigned articles on the Canadian Pension Plan (CPP) and make notes on the pros and cons of pension adoption discussed in each

Read More »

Assignment 2: Recorded Presentation

Weighting Percentage: 45% The purpose of this assessment task is to link an Aboriginal and / or Torres Strait Islander artwork with an issue that relates to health and wellbeing of Aboriginal and Torres Strait Islander people and explore the associated cultural and historical factors.  Each student is required to plan, create and submit

Read More »

Assignment 2 Research Proposal

ASSIGNMENT TWO GUIDE The Research Proposal This document contains everything you need to know for your second assignment. Please make sure to read this in full prior to asking any questions on Moodle. Below are the key things covered and the corresponding page numbers for easy access. Assignment 2 Research

Read More »

NUR133 ASSESSMENT 2 – Digital Presentation

NUR133 ASSESSMENT 2 – Digital Presentation (500 words + 10-minute presentation) TASK Select a service or program designed to improve the health outcomes of Aboriginal and/or Torres Strait Islander people and prepare a poster presentation that could be used to develop a brief, engaging education session for your peers. In

Read More »

MGMT2007 Organisational Behaviour

2021, MGMT2007 Organisational Behaviour 3,000-word Major Essay Pick ONE of these major essay questions to write an essay: Topic 1: Dealing with problems in an organisation under organisational change Example Scenario: Organisation X has implemented some drastic organisational changes recently. As a result, some of its employees have been laid

Read More »

NSB204 MENTAL HEALTH: Self and Others

Assessment Task 2 Assessment name: Case Study Task description: This assignment aims to help you to begin to use your professional and clinical judgement to think like nurses working in a mental health setting and/or in relation to the mental health needs of people regardless of the setting.   Choose

Read More »

MBA600 Business Report Individual written analysis

Assessment 2 Information Subject Code: MBA600 Subject Name: Capstone: Strategy Assessment Title: Assessment Type: Length: Business Report Individual written analysis 2000 words (+/- 10% allowable range) Weighting: 35% Total Marks: Submission: 100 Online Due Date: Week 10 Your task Using the same organisation from the first assessment, individually, you are

Read More »

HNN300 Child and Adolescent Health Assessment

Task 1: Written Assignment 1500 words (40%) Purpose of assessment task Childhood immunisation is a critical public health intervention that helps protect health and support normal development in infants, children, and young people. This assignment is designed to help you to analyse data, assess risk, and to develop skills to

Read More »

Importance of Aboriginal language

Due Date: 12 hrs   Format/Length: 800 words written Purpose: To explore, deconstruct and analyses the importance of Aboriginal language(s) in a contemporary context.  Task: You are to select an Aboriginal language initiative to research and develop your knowledge and understanding on the importance of keeping languages alive. This can

Read More »

Diverse Populations and Nursing Practice Reports

WORD LIMIT – 2500 – no introduction and conclusion required 7 headings required – headings, text-citations,                1200 words 1) Social determinants of health – 300 words 2) Health inequalities – 300 words 3) Health inequities – 300 words 4) Health outcomes – 300 words 1200 words 5) Application of

Read More »

Chronic Diseases

Introduction: The term “chronic disease” is increasingly often used by patients, healthcare professionals, researchers, etc. This term is defined differently by each person, and each definition encompasses a different set of medical disorders. Last but not least, the World Health Organization asserts that chronic illnesses are not contagious. They progress

Read More »

3. REPORT – Essay

STUDENT INSTRUCTIONS You are required to write a report as outlined in the assessment instruction and criteria listed below. It is important to ensure you read all aspects of the assessment topics and discuss any areas that require clarification with your assessor. Where there is a word limit it is

Read More »

Quality Areas 2 and 5 of the National Quality Standard

Access and review each of the Quality Areas in the ACECQA website, and for each of the given elements, provide one requirement that the element requires from an early years learning centre. You can access the page on the Quality Areas of the NQS using the link below: Quality Area

Read More »

National Health and Medical Research Council

Element Underpinning regulation from National Regulations Requirement of the regulation Underpinning section from the ECSNL Requirements of the section Element 2.1.1: Wellbeing and comfort         Element 2.2.1: Supervision         Element 5.1.1: Positive educator to child interactions         Element 5.2.2: Self-regulation  

Read More »

International Health and Development

Assessment Brief Module title: International Health and Development Assessment Point: First assessment point Assessment task: PART A: PowerPoint Presentation: 15 slides PART B: Word document: 1000-word count limit script for the slides Submission deadline: Please consult the VLE. Submission procedure: Please submit via the submission link on the VLE. Submission

Read More »

Outline the historical development of the policy

Outline the historical development of the policy including other linked policies highlighting key changes The Disability Support Pension is Australia’s universal health insurance scheme that guarantees all people who are unable to work due to a physical, mental, or intellectual disability financial help, which is a payment administered by Centrelink (Legal Services

Read More »

 SITHCCC027 – Prepare dishes using basic methods of cookery

Student Name  Student ID  Unit Name   SITHCCC027 – Prepare dishes using basic methods of cookery Practical Date  Submission Date  Student Declaration ☐ Student Plagiarism Declaration: By submitting this assessment to the college, I declare that this assessment task is original and has not been copied or taken from another source

Read More »

SITHCCC027 – Prepare dishes using basic methods of cookery

Student Name    Student ID   Blc01102 Unit Name   SITHCCC027 – Prepare dishes using basic methods of cookery Practical Date   07/02/2023 Submission Date    Student Declaration ☒ Student Plagiarism Declaration: By submitting this assessment to the college, I declare that this assessment task is original and has not been copied or

Read More »

Resource – Health promotion resource

ASSESSMENT:-             Resource – Health promotion resource Due date: – 10th August 2021   Length: – N/A Type of Collaboration:-                Individual Assessment Details It is the nurse’s role to provide information and education to enhance people’s control over their health (NMBA, 2016). The purpose of this assessment is to produce a

Read More »

The Aged Care Royal Commission Final Report

Discussion PAPER Assignment References 8 Australian Harvard 800 words  due 10th august The Aged Care Royal Commission Final Report titled Care, Dignity and Respect has now been released. The report calls for significant reforms to Australia’s aged care system. The final report also makes 148 recommendations for reform. In this

Read More »

HC3131 Business Research Project

Assessment Details and Submission Guidelines Trimester T2 2021 Unit Code HC3131 Unit Title Business Research Project Assessment Type 1, Topic Approval, Presentation Assessment Title Topic Approval Purpose of the assessment (with ULO Mapping) 1.Clearly identify your chosen topic, having carried out some basic review of available secondary data to secure

Read More »

Cases: Assessment Task 2

Case 1 Tina Tina is 18 years old and lives with her grandmother, older brother and two younger sisters. At present no one has a full-time job with both the grandmother and older brother currently on welfare. The two younger sisters currently enrolled in high school. Tina’s mother lives in

Read More »

NURBN3030 Supplementary Assessment

Written Case Study Report Application of health assessment, planning, implementation and evaluation of professional nursing care to a clinical deterioration patient scenario Due date:         As specified by the Course Coordinator Weighting:       Students must achieve a Pass grade (50%) for the Supplementary Assessment to achieve a Pass grade overall for the

Read More »

Competitive Advantage Video Project

Assessment 1 Information Subject Code: MBA600 Subject Name: Capstone: Strategy Assessment Title: Assessment Type: Length: Competitive Advantage Video Project Individual video recording 10 minutes (no more) Weighting: 25% Total Marks: Submission: 100 Online Due Date: Week 6 Your task Individually, you are required to record a 10-minute video, in which

Read More »

Analysis of Foundational Theory of Management

Class: Day and Time   Lecturer name   Student name / ID   ASSESSMENT 1 (30%) Written – Individual   Due:  Week 4 – Sunday, 15 August 2021 @ 23:59 Analysis of Foundational Study of Management – in the context of contemporary multidisciplinary business This assessment task is designed to address

Read More »

Relating the Class to World Events

Submit your assignment soon Even though your assignment is due on Aug 23, 4:59 PM AEST, try to submit it 1 or 2 days early if you can. Submitting early gives you a better chance of getting the peer reviews you need in time. Topic: Relating the Class to World

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?