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. ...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
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

Related Essays

Object Database Management System
A database is a set of records stored in a computer in an organized way, so that a computer program is able to consult it to answer questions. For better recovery and sorting, each record is generally organized as a set of data elements. The objects retrieved in reply to queries become information that can be used to make decisions. The computer program used to control and query a database is known as a database management system.
8 pages (2000 words) Essay
Database Technology
Today, with the increasing data requirements and storage needs, the databases have gone a step further. The emergence of data warehouses or advanced databases support huge data storage needs and provide analytical capabilities to stored data. The data stored in such databases includes the past data and archives too along with the current one.
13 pages (3250 words) Essay
Object Relational Database
The same theme is followed in ORDB, means before creating an object table, a type or class, which represents a real life model is declared. That type describes the attributes (data) and operations (methods) of an object record. Depending on this type, an object table is created, which is going to hold record objects of that type.
12 pages (3000 words) Essay
Database Design
The primary entity in the validations information model is the meter assigned to the customer, as this is a unique entity for every customer. The meter assigned to the domestic customers in the market not only provides the flexibility for the organization to effectively identify the customer and his/her consumption but also provides the ability for the company to conduct regular maintenance on the meters so as to prevent any malfunctioning and abuse of the facility provided to the customers.
14 pages (3500 words) Essay
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
Find out how much would it cost
to get a custom paper written by a pro 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