Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Create a 6 page essay paper that discusses Relational Database Design.Download file to see previous pages... A many-to-one relationship must be made between the Session table ( a group of the Lecture
Create a 6 page essay paper that discusses Relational Database Design.
Download file to see previous pages...A many-to-one relationship must be made between the Session table ( a group of the Lecture table and the Practical table) and the Module table. The Lecture table and the Practical table are both join tables which allow the necessary one to many relationship with the Tutor table and the Session table and the many-to-many relationship between Tutor and Session table. A one-to-many relationship should be constructed between the Tutor table and the Lecture table. Finally, a many-to-many relationship between the table Tutor and the table Practical must be created. The versions of MySQL used for this exercise the relationship of many entities to many must be made through an outer join, represented by the join table. This is displayed in the figure below in paragraph 2.b. These specifications have been duplicated in the attached appendices with the required SQL code.
a. The schematic describing the logical data model is illustrated in paragraph 2. b. below. It uses the American Standard diagrams used to describe functionality and relational integrity found in A Guide to Developing Client/Server SQL Applications, Khoshafian, Setrag, 1992.
b. Logical Data Model Schema:
c.
Appendices:
I. Table Definition.
a.The Textbook Table.
Welcome to the MySQL monitor. Commands end with . or g.
Your MySQL connection id is 2 to server version: 4.1.12-nt
Type 'help.' or 'h' for help. Type 'c' to clear the buffer.
mysql>. use Relational.
Database changed
mysql>. CREATE TABLE Textbook (
->. Tid INT,
->. Chapter INT,
->. Mid INT,
->. PRIMARY KEY(Tid)).
Query OK, 0 rows affected (0.15 sec)
mysql>. INSERT INTO Textbook VALUES
->. (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),(6,6,6),(7,7,7),(8,8,8),
->. (9,9,9),(10,10,10),(11,11,11),(12,12,12),(13,13,13),(14,14,14),
->. (15,15,15),(16,16,16),(17,17,17),(18,18,18),(19,19,19),(20,20,20),
->. (21,21,21),(22,22,22),(23,23,23),(24,24,24),(25,25,25),(26,26,26),
->. (27,27,27),(28,28,28),(29,29,29),(30,30,30),(31,31,31),(32,32,32).
Query OK, 32 rows affected (0.11 sec)
Records: 32 Duplicates: 0 Warnings: 0
mysql>. DESCRIBE Textbook.
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| Tid | int(11) | | PRI | 0 | |
| Chapter | int(11) | YES | | NULL | |
| Mid | int(11) | YES | | NULL | |
+---------+---------+------+-----+---------+-------+
3 rows in set (0.07 sec)
mysql>. SELECT * FROM Textbook.
