Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design Of Database System COurse Using the toyu database (which is provided separately), write the domain relational calculus (DRC) expressions for the following data problem.

Design Of Database System COurse

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

Using the toyu database (which is provided separately), write the domain relational calculus (DRC) expressions for the following data problem. Note that tuple relational calculus is not acceptable. You may copy and paste the following symbols if desirable: E EVAYS - (or -). Multiple step answers are acceptable. List the student id, class id, rooms and grades of all classes enrolled by Mary Hawk. | stuid | classid | room | grade | 1000011 | 100001 10000 | D241 | NULL 10001 | 0242 | A- 2,019 To University (toyu) relations toyu.class: 14 rows total (approximately) classId courseld semester year facid room 10,000 2,000 Fall 1,011 D241 10,001 2,001 Fall 2,019 1,011 D242 10,002 2,002 Fall 2,019 1,012 D136 10,003 2,020 Fall 2,019 1,014 D241 10,004 2,021 Fall 2,019 1,014 D241 10,005 2,040 Fall 2,019 1,015 D237 10,006 2,041 Fall 2,019 1,019 0217 10,007 2,060 Fall 2,019 1,020 B101 10,008 2,080 Fall 2,019 1,018 D241 11,000 2,000 Spring 2,020 1,011 D241 11,001 2,001 Spring 2,020 1,013 D242 11,002 2,002 Spring 2,020 1,013 D136 11,003 2,020 Spring 2,020 1,016 D217 11,004 2,061 Spring 2,020 1,018 B101 toyu.course: 11 rows total (approximately) courseld rubric number name 2,000 CSCI 3333 Data Structures 2,001 CSCI 4333 Design of Dat... 2,002 CSCI 5333 DBMS 2,020 CINF 3321 Introduction t... 2,021 CINE 4320 Web Applicati... 2,040 ITEC 3335 Database Dev... 2,041 ITEC 3312 Introduction t... 2,060 ENGL 1410 English I 2,061 ENGL 1311 English II 2,080 ARTS 3311 Hindu Arts 2,090 ACCT 3333 Managerial Ac... credits 3 3 3 3 3 3 3 4 3 3 3 toyu.department: 7 rows total (approximately) deptCode deptName schoolCode numFaculty ACCT Accounting BUS 10 ARTS Arts HSH 5 CINF Computer Inf... CSE 5 CSCI Computer Sci... CSE 12 ENGL English HSH 12 ITEC Information T... CSE 4 MATH Mathematics CSE 7 toyu.school: 4 rows total (approximately) schoolCode schoolName BUS Business EDU Education HSH Human Sciences and Humanities CSE Science and Engineering toyu.faculty: 11 rows total (approximately) Next facid fname Iname deptCode rank 1,011 Paul Smith CSCI Professor 1,012 Mary Tran CSCI Associate Professor 1,013 David Love CSCI (NULL) 1,014 Sharon Mannes CSCI Assistant Professor 1,015 Daniel Kim CINF Professor 1,016 Andrew Byre CINF Associate Professor 1,017 Deborah ITEC Professor 1,018 Art Allister ARTS Assistant Professor 1,019 Benjamin Yu ITEC Lecturer 1,020 Katrina Bajaj ENGL Lecturer 1,021 Jorginlo Neymar ACCT Assistant Professor Gump toyu.student: 10 rows total (approximately) stuld fname Iname 100,000 Tony Hawk 100,001 Mary Hawk 100,002 David Hawk 100,003 Catherine Lim 100,004 Larry Johnson 100,005 Linda Johnson 100,006 Lillian Johnson 100,007 Ben Zico 100,008 Bill Ching 100,009 Linda King major CSCI CSCI CSCI ITEC ITEC CINE CINF (NULL) ARTS ARTS minor CINF CINE ITEC CINE (NULL) ENGL ITEC (NULL) ENGL CSCI Next s credits advisor 40 1,011 35 1,011 66 1,011 20 1,017 66 1,017 13 1,015 18 1,015 16 (NULL) 90 1,018 125 1,018 To University (toyu) relations

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

Logidata+ Deductive Databases With Complex Objects Lncs 701

Authors: Paolo Atzeni

1st Edition

354056974X, 978-3540569749

More Books

Students also viewed these Databases questions