Relational Database Design - Assignment Example

Comments (0) 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 PAPER93% 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 (0)
Click to create a comment or rate a document
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
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
Relational Database
...in size as storage costs are not of much concern today. Data warehouses act as archives and analytical tool for the historical data. Relational DatabaseRelational DatabasesRelational database was a revolution in the field of databases. The idea of having a tabular structure composed of rows and columns was a ground breaking proposition to make storage and retrieval easier than ever before. Peter Rob in his book describes the relational database in terms of storage and representation. The relational database model allows the designer...
8 Pages(2000 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
Database Design
...Database design Databases are the key components of successful businesses. They help businesses manage their resources efficiently. This is why pop and mom Enterprise wishes to design the following databaseDatabase Design List of entities and relationships The video store keeps stock of the videos. Customers on the other hand request for the videos. The store then rents the DVDs to the customers. The store maintains names and phone numbers for each customer. Each of the movies/DVDs in the store has a title and a unique movienumber together with serial number from the producer that is used to identify it....
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!
logo footer
Contact us:
+16312120006
Contact Us Now
FREE Mobile Apps:
  • StudentShare App Store
  • StudentShare Google play
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • Miscellaneous
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us