Question
Following is a relational database which consists of one table CSC9999 (student_id, name, dept, program, total_credits). Assume that the table below currently contains the following
Following is a relational database which consists of one table CSC9999 (student_id, name, dept, program, total_credits). Assume that the table below currently contains the following data records.
a. What is the primary key for the relation?
b. What are the domain constraints for each of the attributes in the table?
c. Retrieve sid, name, program and credit for students from ECE departments (display the results in a table).
name dept program credit 123 John ECE B.S. 21 356 Mike MATH B.S 142 | Tina | CHEM | Ph.D. | 48 267 David CSC M.S.27 238 Kai 874 Laura ECE B.S. 30 36 CSC M.S. 21Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Directions In Databases 12th British National Conference On Databases Bncod 12 Guildford United Kingdom July 6 8 1994 Proceedings Lncs 826
Authors: David S. Bowers
1994th Edition
3540582355, 978-3540582359
