Question: is this clear please help me answer - The SLRAutsalai Sada Statest Net Cates . Facy Cuttaa CTUAL Haitian Fol COMPUTER SCIENCE INTELLIGENCE INTERNATIONAL MAHETING

is this clear please help me answer

- The SLRAutsalai Sada Statest Net Cates . Facy Cuttaa CTUAL Haitian Fol COMPUTER SCIENCE INTELLIGENCE INTERNATIONAL MAHETING INOR C G CT 1 MANI ( tagiry the anies tail TH the nuy TN ans wa 4 Answer the questions below 25 mars (a) The following SIX (6) tables will be used to generate SQL statements for the queries Student Studentld. Student Name Email) Student la Student Name Miley Cyrus 21258 Justin Bieber 12589 Email Miley agua.com Justice Schemalaya.com Selena Go Owlified Encalty Id.Coreld. Dasund Faculty Cound Qualified 2143 CT 1234 2005 2141 CS 3450 3467 KM355 2007 4756 CT1234 2008 Faculty Excalid. Faculty Name) Faculty Faculty Name COMPUTER SCIENCE 2143 4467 BUSINESS INTELLIGENCE 4756 INTERNATIONAL MARKETING Section Section Sn. Semester, Corld Section No Semester Car 2712 1-2005 CT 1254 1-2008 CS3450 2713 2714 1-2005 KMI255 Continued 4/2 BLES DAGENESEM Course(Consel.CoName Coursed Con Name CT 1214 System Analysis Conce CSET Section Section Se. Semester.Com Section No Semester CH 5 of 7 CT 1234 1 1.2008 2712 2713 2714 1-2008 CS350 1-3005 KM355 Continued Course Courseld. CourseName) Could Con Name CT 1244 CS 3454 System Anal Dute C Knowledge Management KM 3255 Registration Studenildtion Semester Student M Section No Sot 12519 2712 1-30 21258 1-2008 2713 2714 6625 (1) Display the semester which do not contain section 2714 ti) Display the course ID and cose name for all cens with a CT era im Which instructors are qualified to teach CS34547 (iv) is any instructor qualified to teach 3454 and not qualified to teach CT123 How many students are enrolled in sectice 2714 during semester - mark (V) How mumy students are enrolled in ISM 3113 during semester 1-2008 b) Brietly explain the rewas to create a view using SOL and bow view and reinforce data security Continued (i) Display the semester which do not contain section 2714. (3 marks) (ii) Display the course ID and course name for all courses with an CT prefix. (3 marks) (ii) Which instructors are qualified to teach CS3454? (4 marks) (iv) Is any instructor qualified to teach CS3454 and not qualified to teach CT12342 (4 marks) (v) How many students are enrolled in section 2714 during semester 1-2008? (3 marks) (vi) How many students are enrolled in ISM 3113 during semester 1-2008? (3 marks) (b) Briefly explain the reasons to create a view using SQL and how a view can be used to reinforce data security. (5 marks) Continued. 5/2 DM2384 DATABASE MANAGEMENT SYSTEM JUNE 2021 mo - The SLRAutsalai Sada Statest Net Cates . Facy Cuttaa CTUAL Haitian Fol COMPUTER SCIENCE INTELLIGENCE INTERNATIONAL MAHETING INOR C G CT 1 MANI ( tagiry the anies tail TH the nuy TN ans wa 4 Answer the questions below 25 mars (a) The following SIX (6) tables will be used to generate SQL statements for the queries Student Studentld. Student Name Email) Student la Student Name Miley Cyrus 21258 Justin Bieber 12589 Email Miley agua.com Justice Schemalaya.com Selena Go Owlified Encalty Id.Coreld. Dasund Faculty Cound Qualified 2143 CT 1234 2005 2141 CS 3450 3467 KM355 2007 4756 CT1234 2008 Faculty Excalid. Faculty Name) Faculty Faculty Name COMPUTER SCIENCE 2143 4467 BUSINESS INTELLIGENCE 4756 INTERNATIONAL MARKETING Section Section Sn. Semester, Corld Section No Semester Car 2712 1-2005 CT 1254 1-2008 CS3450 2713 2714 1-2005 KMI255 Continued 4/2 BLES DAGENESEM Course(Consel.CoName Coursed Con Name CT 1214 System Analysis Conce CSET Section Section Se. Semester.Com Section No Semester CH 5 of 7 CT 1234 1 1.2008 2712 2713 2714 1-2008 CS350 1-3005 KM355 Continued Course Courseld. CourseName) Could Con Name CT 1244 CS 3454 System Anal Dute C Knowledge Management KM 3255 Registration Studenildtion Semester Student M Section No Sot 12519 2712 1-30 21258 1-2008 2713 2714 6625 (1) Display the semester which do not contain section 2714 ti) Display the course ID and cose name for all cens with a CT era im Which instructors are qualified to teach CS34547 (iv) is any instructor qualified to teach 3454 and not qualified to teach CT123 How many students are enrolled in sectice 2714 during semester - mark (V) How mumy students are enrolled in ISM 3113 during semester 1-2008 b) Brietly explain the rewas to create a view using SOL and bow view and reinforce data security Continued (i) Display the semester which do not contain section 2714. (3 marks) (ii) Display the course ID and course name for all courses with an CT prefix. (3 marks) (ii) Which instructors are qualified to teach CS3454? (4 marks) (iv) Is any instructor qualified to teach CS3454 and not qualified to teach CT12342 (4 marks) (v) How many students are enrolled in section 2714 during semester 1-2008? (3 marks) (vi) How many students are enrolled in ISM 3113 during semester 1-2008? (3 marks) (b) Briefly explain the reasons to create a view using SQL and how a view can be used to reinforce data security. (5 marks) Continued. 5/2 DM2384 DATABASE MANAGEMENT SYSTEM JUNE 2021 mo

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please answer this questions below, I really need help on this questions, I know it's blurry but please could you zoom in and see it would make you see clear, please help me on this questions I...

help me please in recording more clear pictures more clear please help. more clear pics of data it is only one question. u have to record read the record question. this is only one question that have...

I want to modify the codes. For the output to be true Accont: ArrayEmception: Bank: BankTest: DuplicateException: MyArray: MyArrayImpl: OutOfSpaceException: This is the photo so clear please help me...

please help asap hope this new ones are clear.. please help asap Support My Subscription the following transactions during the month of ue tung 000s of common for $100.000 ch 2. Jana Much 120.000 of...

please help asap hope this one is clear please help asap 130214 o con 2140 006 F TS 32704 Contelidated Balance sheet As of December 31, 2020 Liabilities and stockholders' Equity Current 315393...

Finance just short answer please A or B or C or D or E Finance management plz help to answer yeah sorry now its clear please help to answer thanks I 7. The expected rates of return of stocks A and B...

Hi, for my operations management class I need to build a prototype for a mobile application that implements a concept or tools from operations management. I'll make the app itself but I need help...

I have sand many copy of this sorry , but try to see this one . I try hard to make it clear because it come from the school not clear. please help me to answer this. Unit 5 Comprehensive Assignment...

PICTURES ARE CLEAR! - PLEASE HELP IN FINDING THE ANSWERS BE PART OF THE SOLUTION! Our storical results for any prior period are not necessarily indicative of results expected in any future period Ge...

a. Make the description of the problem b. Perform the ERD (Visual Paradigm type notation) c. Generate the DB d. Create an index for the journal entity that allows for better searches, give at least...

Andersons Department Store has the following data for inventory, purchases, and sales of mer- chandise for December: Andersons uses a perpetual inventory system. All purchases and sales were for...

A list of cash receipts and cash payments for Mexis Communications is presented below. Classify each amount as operating, investing, or financing. Use the direct method. Cash Receipt or Payment Cash...

What is a lien? Multiple Choice A bailment for mutual benefit The charges for delivery of any bolled property A charge against property to secure the payment of a debt Compensation by a bailee for...

Read the following case and fully answer the question at the end. Answers must contain sufficient detail. Answers will be several paragraphs in length (you can use point form if you wish) . The...