StudentShare solutions
Triangle menu

Relational Database Design - Assignment Example

Extract of sample
Relational Database Design

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;
+-----+---------+------+
| Tid | Chapter | Mid |
+-----+---------+------+
| 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 |
| ...Show more

Summary

This paper describes the process of creating a relational database. It includes the SQL code (MySQL) for creating the tables, the joins to create the necessary relationships and the results of those SQL runs. It describes the specifications of the proposed system, the logic of that system, the table definitions and contents, a live transaction which inserts data and one that deletes it and finally a non-trivial query which demonstrates multiple joins, group functions, qualifiers and correlation variables.
Author : samanthadeckow
Relational Database Design essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Relational Database Design"
with a personal 20% discount.
Grab the best paper

Check these samples - they also fit your topic

Relational Database Assignment
The four prime factors that control the integrity of a database include relationship-level integrity, attribute-level integrity, business rules, and entity-level integrity (Lathem, 2008). Using these relationships, one can divide the data in separate tables.
3 pages (750 words) Assignment
OOP Features Added to Oracle Database
Oracle Database were no exception to this fact. The overwhelming popularity of OOP modeling techniques had some solid grounds which bond other languages and techniques to extend their support for it and many contemporary writers have admitted this fact, “The object-oriented method promised to improve software quality and efficiency.
4 pages (1000 words) Assignment
Database
The second layer is the schema of a given database. The third layer is the database itself representing a state of the application's data often called micro-data. The fourth layer consists of the macro-data that are generated from the micro-data by application of view queries to the micro-data (DIETRICH, 2011).
6 pages (1500 words) Assignment
Database Design and Implementation
Each book has a book number, title, the number of pages of the books, the name of the publisher, the year of publishing, and list of authors of the book. Each library could own zero to several copies of the same book. The database might store the author's name of each book and other information.
10 pages (2500 words) Assignment
Database
Each asset is regularly inspected, and the date of the inspection, the person who carried out the inspection and details of any maintenance actions are noted. If the asset is a photocopier then the toner is replaced and the total number of copies made is recorded as well as the toner serial number.
4 pages (1000 words) Assignment
Database systems analysis & design
It then highlights how the design confirms the three forms of normalization i.e. 1NF, 2NF and 3NF. In order to test the working of the proposed logical design, results of certain test cases have also been presented. The
12 pages (3000 words) Assignment
Database Design and Implementation
A major pitfall exists in the payment duration; the buyer’s payment can take up to a fortnight since it goes through Ubid which can cause a serious cash flow problem for the new sellers. E-bid auction is one of the largest auction sites in the UK. It is the second
20 pages (5000 words) Assignment
Database and Data Warehousing Design
There is a storage space of data warehouses for maintaining the historical in addition to the most recent data. This historical data is designed to develop and enhance diverse fads and records available to the senior management in a way that the management makes use of the
11 pages (2750 words) Assignment
INtro to rela dbase Business Intelligence and Data Warehouses week 9
Performing vast expository inquiries on a particular database is not advisable since it affects the systems performance (Ahlemeyer-Stubbe & Coleman, 2014). An explanatory inquiry could take a few minutes to handle. On the other side, a data warehouse is customized for
2 pages (500 words) Assignment
Data base coursework assignment
For efficient services, Pronto Pizzas needs to implement a reliable database that will serve both the administration and the customers. The database should put into consideration several features such as load time and usability. Entities specify distinct
4 pages (1000 words) Assignment
Hire a pro to write
a paper under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Click to create a comment