Exercise Consider the following relational database: (STDNO, SNAME, DEPTNO#) (DEPTNO, DNAME) (CORSNO, CNAME, DEPTNO#, CMAX) ENROLMENT (STDNO#, CORSNO#, GRADE, EDATE) STUDENT DEP COURSE STUDENT.DEPTNO is the department number of the student. COURSE.DEPTNO is the department number that offers the course. ENROLMENT models the registrations of students in courses (M:M relationship) where the GRADE is the grade obtained by the student in the course. PART I: DATA DESCRIPTION LANGUAGE (DDL) 1) Write DDL commands to create the four tables without any constraint. Nom de colonne Signification Size Турe Number STDNO Student Number 8. SNAME Student name Varchar2 30 Department Number Department name Course Number DEPTNO Varchar2 DNAME Varchar2 20 CORSNO Number 3 CNAME Course Name Varchar2 30 СМАХ Max. students allowed Number 2 GRADE Obtained Grade Number EDATE Enrolment date Date

Q: eans that: Question 4 options: Not only SQL is us

A: Accessing Data with NoSQL Means that: Question 4 options: Not only SQL is used Only SQL is used No…

Q: Explain the null functions in Oracle Sql

A: Software programs known as database management systems make it easier to create, organize, retrieve,…

Q: Write an SQL query to answer the following question: Which instructors are qualified to teach ISM…

A: In this problem, we will write sql query to find the instructor who are well qualified to teach ISM…

Q: Describe the concept of user-defined data types (UDTs) in SQL. Provide examples of situations where…

A: In SQL (Structured Query Language), a User-Defined Type (UDT) allows users to create custom data…

Q: Explain the null functions in Oracle Sql

A: Null functions in Oracle SQL are essential for controlling and modifying null values in database…

Q: Explain how to work pl/sql block.

A: Procedural Language/Structured Query Language, or PL/SQL, is a potent SQL extension meant for…

Q: What is the purpose of SQL?

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

Q: Please identify the necessary PL/SQL block subsection. Also, explain in detail the three subsections…

A: A PL/SQL block consists of three sections: declaration, executable, and exception-handling sections.…

Q: Please offer a brief overview of the DML transactions that PL/SQL supports, as well as the…

A: Language for Data Manipulation (DML): These SQL statements work with the database's data to…

Q: Explain when you would use embedded SQL as opposed to standard SQL or a general-purpose programming…

A: Introduction: As a result, SQL may be integrated into a programming language, allowing the host…

Q: Please identify the required subsection of a PL/SQL block. Also, provide a concise explanation of…

A: The question has been answered in step2

Q: Write syntax for DELETE and TURNCATE in SQL databases.

A: Question. Write syntax for DELETE and TRUNCATE in SQL databases. Answer. DELETE: This query is used…

Q: Define the following aggregate functions in an SQL Query. COUNT, MIN, MAX, SUM, AVG

A: We are going to learn about few SQL functions and these are aggregate functions of sql: