STUDENT (StudentID, StudentName) FACULTY (FacultyID FacultyName) COURSE (CourselD CourseName) SECTION (SectionNo, Semester ,CourselD) REGISTRATION (StudentID, SectionNo) a) Use SQL to define a view to show CourselD and Course Name. b) Write SQL data definition command to remove the Registration table c) Write a command that will remove student 'Ahmed' from the Student table. d) Write SQL queries to answer the following questions: What is the smallest ection number used in the fall semester? e) Write SQL queries to answer the following questions: How many courses are there in the university?

STUDENT (StudentID, StudentName) FACULTY (FacultyID FacultyName) COURSE (CourselD CourseName) SECTION (SectionNo, Semester ,CourselD) REGISTRATION (StudentID, SectionNo) a) Use SQL to define a view to show CourselD and Course Name. b) Write SQL data definition command to remove the Registration table c) Write a command that will remove student 'Ahmed' from the Student table. d) Write SQL queries to answer the following questions: What is the smallest ection number used in the fall semester? e) Write SQL queries to answer the following questions: How many courses are there in the university?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What is information. Explain types of information.
DML refers to the language used to manipulate data. Explain what it is.
Define the terms "DBMS" (Database Management System) and "RDBMS" (Relational Database Management System). Explain why relational databases are widely used.
accessing and modifying data in a relational database with a computer programming language
What is information. Explain types of information.
Explain the different types of databases and their uses.
Describe the process of designing and developing a database.
Relational databases store data in tables that are organized into columns and rows, sometimes called records and cells. T or F
Do you know how to enter user data into a database?
What is physical and logical blog explain it (database question)
Explain how patent rights may be used economically and protected.
Explain the role of the database administrator in the development, implementation and maintenance of a database system.