Question: Given the RM bellow Student ( studno , studname , DoB , add, Phonum , GPA) Course ( courseno , coursname , coursabrv , NbH

Given the RM bellow

Student ( studno , studname , DoB , add, Phonum , GPA)

Course ( courseno , coursname , coursabrv , NbH )

Enrol ( studno , courseno , labmark , exam_mark )

1. Make a view called Tot_mark_view that provide student name, course name & total marks for all student.

1. Can we make DML request through this view, why?

2. Make a view called Av_C_view that provide lab mark average & final_exam mark average for MIS433 student.

1. Can we make DML request through this view, why ?

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 Databases Questions!

Q:

} RM bellow } Student (studno studname DoB add Phonum GPA) } (courseno coursname coursabrv NbH) } (studno courseno labmark exammark) }

Q:

From the book Networks, Crowds, and Markets: Reasoning about a Highly Connected World. By David Easley and Jon Kleinberg. Cambridge University Press, 2010. Complete preprint on-line at...

Q:

Life Situation Evlyn, Age 22, Single lady with No dependents, College student with an illness Financial Data Monthly Income (after taxes) RM 2,450 Personal Property RM 8,300 Savings RM 2,500 Student...

Q:

Life Situation Evlyn, Age 22, Single lady with No dependents, College student with an illness Financial Data Monthly Income (after taxes) RM 2,450 Personal Property RM 8,300 Savings RM 2,500 Student...

Q:

Life Situation Evlyn, Age 22, Single lady with No dependents, College student with an illness Financial Data Monthly Income (after taxes) RM 2,450 Personal Property RM 8,300 Savings RM 2,500 Student...

Q:

Life Situation Evlyn, Age 22, Single lady with No dependents, College student with an illness Financial Data Monthly Income (after taxes) RM 2,450 Personal Property RM 8,300 Savings RM 2,500 Student...

Q:

(d) Two Permanent Magnet Moving Coil (PMMC) Meters are used by Student A and B to measure voltage. The meter specifications are as follow: Meter 1: Sensitivity (S) = 0.5 k2/V, Internal Resistance...

Q:

English Question: Display the Student name, Course Name, Semester and Section and grade for the student with this . Write a procedure COURSES_BY_STUDENT (bannerId VARCHAR(3)). When executed it...

Q:

Econ homework Problem 3. Two identical rms produce an identical product, and they are the only rms in this market. Their total annual costs are given by T C 1 = 3 00+] 5q1 and T C2 = 200+25q2, where...

Q:

visual Programming q3) please answer both questions thanks c) Based on the given interface by Figure 6.0, write a VB program segment to determine the fee to be paid by a student using the following...

Q:

What are the four primary elements described in the definition of auditing?

Q:

Teicher Company presents the following condensed comparative income statements for 2015, 2016, and 2017: Required: Prepare rate of change analyses for Teicher for 2016 and 2017 using year-to-year...

Q:

On April 1 5 , 2 0 2 3 , Brayden received 1 , 0 0 0 shares of restricted stock from his employer, Alpha Corporation, when the fair market value of the Alpha Corporation stock was $ 2 0 per share....

Q:

2. (20 pts) Cometabolism of trichloroethylene (TCE) by methylotrophic bacteria is considered an effective means of bioremediating a polluted aquifer. The bioremediation process includes oxidation of...

Q:

How do Data Types perform data validation?

Q:

How does Referential Integrity work?

Q:

What are Dimensional Relational Databases designed to hold primarily?