Question: Q1. Convert the Entity Relationship Diagram in to relational database by using SQL Commands (Note: Students has to write the SQL code for creating the

 Q1. Convert the Entity Relationship Diagram in to relational database by

Q1. Convert the Entity Relationship Diagram in to relational database by using SQL Commands (Note: Students has to write the SQL code for creating the tables by using appropriate Primary key and foreign key relationships) [8 Marks] teacher id number(5) PK name varchar2(50) description varchar2(300) teachers_books course_id number(5) PK FK teacher_id number(5) PK FK book_id number(5) PK FKDE description varchar(400) recommendation_date date book id number(5) PK title varchar2(50) + description varchar2(300) id description class number(5) PK varchar2(300) + Q3. Insert atlest 3 rows with valid data in each relation table [4 Marks] Q4. Write an SQL Statement to display teacherID. Name and Description order by name descending

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!