Question

For each of the relationships listed below, indicate if the relationship is on one, one-to-many, or many-to-many. Justify your answer. Student-course Actor-movie Mother-child In the context of relational databases, Explain what is meant by the statement: 'SQL is a non-procedural language'.

Answer 1

Answer to PART 1:

Student- Course: The relationship that exist between Student and course is many to many.

Reason: A student can have many courses that he/she studies and also a course that exist in a school/college can have many Students who study them. A student can study courses like Physics, Chemistry, Maths, English. A subject like English can be studied by many Students.

Actor- Movie: The relationship that exist between Actor and Movie is many to many.

Reason: An Actor can perform in several movies and a movie can have several actors performing in it.

Mother- Child: The relationship that exist between Mother- Child is One to Many.

Reason: A Mother can have several children but a Child can have only one mother that has given birth to him/her.

Answer to PART 2:

SQL is known as non-procedural language because this language determines what should be done and gives no info regarding how it should be carried out. Procedural languages generally require deep knowledge and procedure of the operations that needs to be performed. The lower level operations and procedures are abstracted from the user and hence, SQL implements only the higher level operations. Thus, it is known as Non-procedural language.