Contact Us
Sign In / Sign Up for FREE
Go to advanced search...
Nobody downloaded yet

Ralational Database Design - Lab Report Example

Comments (0) Cite this document
"Relational Database Design" 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 also describes the specifications of the proposed system…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER91.5% of users find it useful
Ralational Database Design
Read TextPreview

Extract of sample "Ralational Database Design"

Download file to see previous pages A many-to-many relationship is required between Module and Field through a join table (outer join or junction table) Field_Detail. 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 too many relationships with the Tutor table and the Session table and the many-to-many relationship between the 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 the functionality and relational integrity found in A Guide to Developing Client/Server SQL Applications, Khoshafian, Setrag, 1992.

All live transactions are shown in Appendix I. These consist of the Create Database Relational. ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(Ralational Database Design Lab Report Example | Topics and Well Written Essays - 4000 words, n.d.)
Ralational Database Design Lab Report Example | Topics and Well Written Essays - 4000 words.
(Ralational Database Design Lab Report Example | Topics and Well Written Essays - 4000 Words)
Ralational Database Design Lab Report Example | Topics and Well Written Essays - 4000 Words.
“Ralational Database Design Lab Report Example | Topics and Well Written Essays - 4000 Words”.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Ralational Database Design

Relational Database System Design

...Relational Database System Design 1. Executive Summary ECT is a project for an organization that deals with the stocking and selling of clothe products. It intends development of a system integrated with a relational database system design and a front-end interface for managing the movement of stock sales of clothes. ECT requires a critical consideration of the relationships that exist between the database tables. The products are classified in different fields as follows, Product ID, Product Name, Style, Color, Size and Cost of each clothe. The structure of the database is as shown below. Product ID Product Name Style Color Size Cost The current system has been facing some challenges with the structure and the design of its database...
4 Pages(1000 words)Admission/Application Essay

Database Design

...Database Design The database design is presented in three stages as identified by Gavin Powell (2005)i. These include Conceptual Design, Logical Design and the Physical Design as described below. Conceptual Design The conceptual design of a database being the element part of the overall development of the design forms a critical segment of the design process. The conceptual design stage of the database predominantly includes the description of the various entities and their relationship with regards to the envisaged business application at a strategic level. In the light of the aforementioned arguments an insight into the validations system design is as follows The primary entity in the validations information model is the meter...
14 Pages(3500 words)Essay

Relational Database Design

...Relational Database Design The Design of a Relational Database by This paper describes the process of creating a relational database. Itincludes 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. Relational Database Design The hallmark of the relational database is that when one table changes in the database all other tables are updated and are current. 1...
6 Pages(1500 words)Assignment

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 use of data values. The data which is found in the table columns cannot be repeated. 2. Enterprise Systems and RDBMS RDBMS...
4 Pages(1000 words)Essay

Database systems analysis & design

... System Database Design Report Table of Contents Introduction 3 System Context 3 Stakeholders 3 Requirement Analysis 4 Requirements 4 2.Business Objects (Entities) 4 Database Design 5 1.ERA Diagram 5 1.1.Entity-Relationship Model (ER Model) 6 1.2.Entity-Attribute Model (EA Model) 7 1.3.Entity-Relationship-Attribute Diagram (ERA Diagram) 8 2.Normalization 9 2.1.Un-normalised Form 9 2.2.First Normal Form (1NF) 10 2.3.Second Normal Form (2NF) 11 2.4.Third Normal Form (3NF) 11 Testing 14 Sample Test Data 14 Test Cases 15 Conclusion 18 Introduction This document demonstrates the concept of normalization while designing the conceptual data model of a University System. This document would provide brief overview of the system, highlighting...
12 Pages(3000 words)Assignment

Database Design and Implementation

...Database Design and Implementation Faculty: Department: Module Academic Year: Semester Data investigation and capture 1 of the three websites chosen 1.1.1 This is an online auction site gaining popularity close to that of e-bay. Even though it does not have as much traffic as e-bay, it generates quite a number of sales. The fact that it does not charge listing fee puts it at a greater competitive edge over the similar online purchasing sites. 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. 1.1.2 E-bid auction is one of the largest auction sites in the UK...
20 Pages(5000 words)Assignment

Database Design- Dependency Diagram

... such as in the shared accesses to the main storage, which is not illustrated in a dependency diagram. A CRUD diagram might also be used to illustrate dependency among some of the processes that are not shown in the dependency diagram such as the year –end time dependency among processes. Fig 1.1 dependency diagram Work cited Bagui, Sikha, and Richard Earp. Database design using entity-relationship diagrams. 2nd ed. Boca Raton, FL: CRC Press, 2012. Print....
1 Pages(250 words)Essay

Database Design Proposal: Analysis

...Health Care Data Management: Database Design Proposal Analysis and User Needs Identification of database users There will be 3 groups of users of the proposed database: 1. Management of the facility 2. Workers at the health centre 3. Patients who are treated at the health care centre Individual needs of database users Top management: to administer the database including altering its structure and layout Workers at the health care centre: data retrieval related to their respective departments Patients: Read-only access to log in and view their own medical record Specific examples of possible uses by the management: The top management would like to know how many patients there are. The management would like to know which patients...
3 Pages(750 words)Essay

Database design

...Database design: The database design is a very critical unit for any individual who has interest in the computer technology field. A database system is a worthy asset of any business organization. As such its administration should be effective. For one to ensure effective database management and administration, one need to fully understand the database design. The unit has enabled me gain substantial knowledge on design and management of database. The course gives a detailed introduction of database design. The introduction to database design gave me in-depth understanding of how the idea of database originated from. From the introduction, I learned that the idea of database management system arose as a result of the unending...
2 Pages(500 words)Essay

Database Design Conflicts

...Database Design Conflicts Introduction People think database design is a simple topic, but in actual fact it is a very complicated subject. In view of the fact that a correctly planned database arrangement is a design of a company, or a number of "things" in the actual world. Thus, similar to their physical model equivalents, data models facilitate them to obtain responses concerning the information that structure the objects being formed. In addition, queries that require answers decide that which details require being stored competently in the data model. In a relational database data is stored in different tables in place of placing all data in one large table. Moreover, in the relational model, data is typically arranged in tables...
9 Pages(2250 words)Research Paper
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 Lab Report on topic Ralational Database Design for FREE!

Contact Us