Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2 . 1 Identify the entities in the given scenario, establish the applicable relationships between the identified entities and use this information to design an

2.1 Identify the entities in the given scenario, establish the applicable relationships between the identified entities and use this information to design an entity relationship diagram. (8 Marks)2.2 Create a database called EduEnrolment using query. (3 Marks)2.3 Create the identified five (5) collections in the given scenario. (5 Marks)2.4 Store at least five (5) records into each table (collection) based on the identified attributes into each entity. (15 Marks)2.5 Select all students (STUDENT) sorted by student name in ascending order. (3 Marks)2.6 Select all instructors (INSTRUCTOR) sorted by instructor identity in ascending and instructor name in descending order. (3 Marks)2.7 Write a query to obtain (find) the information of students (STUDENT) whose names begin with 'A'.(3 Marks)2.8 Update the MODULE collection by setting/changing any of its existing records to a new value and display the records in the MODULE collection to confirm the effect of the update operation. (3 Marks)2.9 Due to dynamic working requirements at Eduvos, an instructor resigned and ought to be deleted. Create a query capable of deleting the record of the instructor who resigned to prevent data inconsistency. Use any instructor ID of your choice, e.g. instructorID 50001.(3 Marks)2.10 Download ALL the database tables (collections) in JSON format and submit them as portfolio of evidence for working with a document database.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions

Question

Define cost of sales. Define operating expense. LO1.

Answered: 1 week ago

Question

10. Identify the atonement with the father in Pinocchio.

Answered: 1 week ago

Question

Write a program to check an input year is leap or not.

Answered: 1 week ago

Question

Write short notes on departmentation.

Answered: 1 week ago

Question

What are the factors affecting organisation structure?

Answered: 1 week ago

Question

What are the features of Management?

Answered: 1 week ago

Question

Briefly explain the advantages of 'Management by Objectives'

Answered: 1 week ago