Question

Instructions: You are required to create ERD and Enhanced ERD diagrams. And also translate your own created ERD & EERD diagrams in to Relational Model. Q# 1: Draw ER diagram based on the following database requirements. A Tutorial class may have one or more students. A student may be in one or more classes. Attributes of CLASS includes CLASS CODE, ROOM NAME and CLASS SIZE. Attributes of STUDENT include STUDENT ID, NAME and NATIONALITY. Translate your ER diagram in to Relational Schema. Write SQL code for table creation of your relation schema. Write SQL code to Insert one record in your tables.

Answer 1

Solution: ER diagram: RoomName Class Size Student_ID Name Class_Code CLASS HT have Nationality -04 STUDENT in Explanation: The above ERD has entities “CLASS” and “STUDENT” which are mentioned in rectangle boxes. The attributes of the entities mentioned in eclipse shape. Relational Schema: Class Student PK Class_Code RommName PK Student ID PK,FK2 Class_Code Class Size Name Nationality -

SQL Code table creation: Create table class (class_code int primary key, roomname varchar2 (10), classsize int); Create table student (student_id int primary key, name varchar2 (10), nationality varchar2 (10),class_code int foreign key references class (class_code)); Insert records: Insert into class values (100, 'A', 100); Insert into student values (10201, 'Stlen', 'xxx', 100);