StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Relational Database Design - Assignment Example

Comments (1) Cite this document
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.
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER98.4% of users find it useful
Relational Database Design
Read TextPreview

Extract of sample "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;
+-----+---------+------+
| 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 |
| ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Relational Database Design Assignment Example | Topics and Well Written Essays - 1500 words”, n.d.)
Retrieved from https://studentshare.org/technology/1528614-relational-database-design
(Relational Database Design Assignment Example | Topics and Well Written Essays - 1500 Words)
https://studentshare.org/technology/1528614-relational-database-design.
“Relational Database Design Assignment Example | Topics and Well Written Essays - 1500 Words”, n.d. https://studentshare.org/technology/1528614-relational-database-design.
  • Cited: 0 times
Comments (1)
Click to create a comment or rate a document
ra
rashawn94 added comment 11 months ago
Student rated this paper as
The topic of "Relational Database Design" was hard to find. I spent ages to find it. Here at StudentShare, I got the finest sample. Many thanks!

CHECK THESE SAMPLES OF Relational Database Design

Applied Finance 2011/2012 Research Project

4 Pages(1000 words)Essay

Relational Database Assignment

...?Relational Database Importance of Relationships in Database Design Relationships play an extremely important role in the design of a database. In order to come up with the most appropriate design, it is imperative that one knows which relationship needs to be used. 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. This assists the user in matching the data with the help of common characteristics...
3 Pages(750 words)Assignment

Information about the Relational Database Business Paper

...-1, 2013). In discussing about the Object Management Group’s Unified Modelling Language, it can be said that it helps in the process of specifying, visualizing and documenting the models of various software systems. While doing so, the focus is given on the fact that it fulfils all the requirements related to structure and design. The OMG’s UML based tools helps in the process of analyzing the requirements of future applications and design solutions which will help in attaining them. The power of OMG UML is that it helps in the modelling of any kind of application, which is running on a variable combination of hardware, programming language, operating system and network (Object...
4 Pages(1000 words)Admission/Application Essay

Relational Database System Design

The current system has been facing some challenges with the structure and the design of its database and the relationship of the data items. The immediately noticeable challenge with the database is the use of important database elements, such as primary keys, foreign keys, and the relationships. The tables apparently require normalization. If the database is not normalized, there is a high risk of the data being inconsistent and lacking integrity. The proposed information management system for the ECT project should have the ability to integrate flawlessly into the ECT Relational Database. The ECT Information Management System infrastructure receives the required data through structural query request, using special criteria for d...
4 Pages(1000 words)Admission/Application Essay

Object Relational Database

...Running head: OBJECT RELATIONAL DATABASE Object Relational Database Vs. Relational database By _______________ ORDB Overview An ORDB (Object relational database) is solely based on Object oriented concepts. As in object oriented programming, a program is a collection of objects. An object represents a real life model encapsulating both data and operations within itself. But before creating such an object, the type/class for that object should have to be declared, depending on its details, the object is instantiated. The same theme is followed in ORDB, means before creating an object table, a type or...
12 Pages(3000 words)Essay

Database Design

...on the meters in order to prevent errors in the readings leading to unwanted reconciliations for the organization. The conceptual design of the database model also includes the use of the billing efficiently both during the period of operation for the meter as well as at the time of removal and installation of the new meter. This method although straight forward in words is actually a complex procedure as it not only involves the company and the customer but also the supplier for the meter that is installed at the customer site. The need for policy compliance and related issues make the process complex and the information model should address this. The conceptual...
14 Pages(3500 words)Essay

Database Design & Development

...Relational Database Management System Definition of RDBMS RDBMS can be defined as a set of modules that helps the organization create, maintain database at a single, centralized point. It is a database management system that is based on a popular model of relational model. This model was devised by E. F. Codd. It is a DBMS that manages the data in the form of tables, even the relation that exists between these tables in stored in the form of tables. RDBMS is based on the concept of relational system, referential integrity and normalization (Chaterjee 2005). All data is held in the form of tables and is described by the...
4 Pages(1000 words)Essay

Relational database solution

...is the rational database solution. A relational data base can be explained or defined as a collection of data or information. The data is then stored in tables where it can be accessed or rearranged in different ways without changing the arrangement of the tables. Relational data base was invented in the 1970 by Edgar Codd at IBM Harrington (2004). The relational database management system is based on the relational model theory. A relational database model has a set of tables which are designed to hold data after collection. The data is arranged and put in categories which have a set...
2 Pages(500 words)Essay

Database design

...to internalize the database design concept. Considering the strength and weaknesses of the database, I realized that database system is inherently important to any organization which uses a computerized system. The advantages outdo the disadvantages by far. The henry books database case is an ideal case study for database design. It provides all the information required in designing a database system. The course also introduced me to relational databases and different low level programming features such as Query-By-Exam (QBE), simple and compound query...
2 Pages(500 words)Essay

Intro to Relat Dbase Mgt Syst week1

...Relational Database Design for Local College Relational Database Design for Local College Rational Database Design enables entities in the database to be linked to each other through relationships. In this paper, this design principle in used to describe a database project for a local college using 3 key entities (Churcher, 2012). Attached to this paper is the database design drawn using Microsoft Visio. This paper aims to show that the diagram reflects the true nature of how the database will be...
1 Pages(250 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Assignment on topic Relational Database Design for FREE!

Contact Us