PART I: DATA DESCRIPTION LANGUAGE (DDL) 1) Write DDL commands to create the four tables without any constraint. Nom de colonne Signification STDNO SNAME DEPTNO Туре Number Size Student Number 8. Student name Varchar2 Varchar2 30 Department Number Department name Course Number 2 Varchar2 Number Varchar2 Number Number DNAME CORSNO 20 3 CNAME Course Name 30 СМАХ GRADE EDATE Max. students allowed Obtained Grade 2 2 Enrolment date Date 2) Add all the following constraints: - Primary Key - Foreign Key - Constraints on the STUDENT table: - Sname: Not Null - Each student must belong to a department Constraint on the ENROLMENT table *- Edate: have a default value equal to the system date.

PART I: DATA DESCRIPTION LANGUAGE (DDL) 1) Write DDL commands to create the four tables without any constraint. Nom de colonne Signification STDNO SNAME DEPTNO Туре Number Size Student Number 8. Student name Varchar2 Varchar2 30 Department Number Department name Course Number 2 Varchar2 Number Varchar2 Number Number DNAME CORSNO 20 3 CNAME Course Name 30 СМАХ GRADE EDATE Max. students allowed Obtained Grade 2 2 Enrolment date Date 2) Add all the following constraints: - Primary Key - Foreign Key - Constraints on the STUDENT table: - Sname: Not Null - Each student must belong to a department Constraint on the ENROLMENT table *- Edate: have a default value equal to the system date.

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

How does SQL Server Integration Services operate?
Explain the concept of indexing in a database. How does indexing improve query performance, and what are some common types of indexes?
Please identify the required subsection of a PL/SQL block. Also, provide a concise explanation of the three subsections that make up a PL/SQL block.
Data storage and retrieval can be performed using SQL alone or embedding SQL in a general-purpose programming language. Describe the circumstances in which you would choose to use i) embedded SQL ii) SQL alone
What is the purpose of the SQL SELECT statement, and how does it work to retrieve data from a relational database?
Count the customers who ordered James Austin books. SQL instructions
How can I practice SQL?
It is necessary to define and clarify the SQL Environment's structure and its constituent parts.
Define the following aggregate functions in an SQL Query. COUNT, MIN, MAX, SUM, AVG
SQL Developer provides a graphical user interface that can be used to send SQL commands to the Oracle Database Management System. Question 30 options: 1) True 2) False
Explain the purpose of the SQL statements START TRANSACTION, COMMIT, and ROLLBACK. How do these statements vary across DBMSs?
Differentiate between embedded sql and dynamic sql. Atleast 5 points.