Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL Homework 1 The schema of the database is provided below (keys are in bold, field types are omitted): . student (sid, studentName, gpa) *

image text in transcribed

SQL Homework 1 The schema of the database is provided below (keys are in bold, field types are omitted): . student (sid, studentName, gpa) * dept (deptName, numPhDs) prof (profName, deptName) .course (cno, courseName, deptName . major (deptName, sid) . section (deptName, cno, sectno, profName) * enroll (sid, grade, deptName, no, sectno) 10. Retrieve the ids, names, and GPAs of the students who are currently taking all of the Civil Engineering courses Query # 1 0 exposes a data inconsistency. For this question, describe the inconsistency and how you would change the design of the tables to eliminate the

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_2

Step: 3

blur-text-image_3

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

Intelligent Information And Database Systems Third International Conference Achids 2011 Daegu Korea April 2011 Proceedings Part 2 Lnai 6592

Authors: Ngoc Thanh Nguyen ,Chong-Gun Kim ,Adam Janiak

2011th Edition

3642200419, 978-3642200410

More Books

Students also viewed these Databases questions