Nobody downloaded yet

Data base design - Essay Example

Comments (0) Cite this document
Summary
Eliminate repeating groups. Make a separate table for each set of related attributes, and give each table a primary key. All attributes must be in their simplest form, meaning none can be broken down into smaller forms.
Eliminate redundant data. If an attribute depends on only part of a multi-value key, remove it to a separate table…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER97.3% of users find it useful
Data base design
Read TextPreview

Extract of sample "Data base design"

Download file to see previous pages ReqLayout
EquipmentType
Room
Roomno (PK)
Name (Room Name or Eating area description)
Roomtype (Conf. Or Eating)
Capacity
Costpersession
Openfor
RefreshmentMealDetail
OrgCode (PK)
RMdate (PK) (where RM is refreshment and Meal)
RMtime (PK)
Roomno/Mealroom (PK)
OrderId (PK)
Ordertype (refreshment / meal)
Quantity
Order
OrderId (PK)
Description (beverage name, lunch, dinner, evening)
3NF
Eliminate columns not dependent on the key. If attributes do not contribute to a description of the key, remove them to a separate table. All non-key fields must be exclusively dependent on the key field. Over here all tables in 2NF are already in 3NF as follows:
Organization
Orgcode (PK)
OrgName
OrgAddress
OrgPostcode
OrgContact
OrgTel
OrgFax
OrgEvent
NosExpected
Booking
OrgCode (PK)
BookDate (PK)
Roomno (PK)
Session (PK)
ReqLayout
EquipmentType
Room
Roomno (PK)
Name (Room Name or Eating area description)
Roomtype (Conf. Or Eating)
Capacity
Costpersession
Openfor
RefreshmentMealDetail
OrgCode (PK)
RMdate (PK) (where RM is refreshment and Meal)
RMtime (PK)
Roomno/Mealroom (PK)
OrderId (PK)
Ordertype (refreshment / meal)
Quantity
Order
OrderId (PK)
Description (beverage name, lunch, dinner, evening)
4NF
Isolate independent multiple relationships. No table may contain two or more 1:n or n:m relationships that are not directly related. All tables which are in 3NF are already in 4NF except "Booking" table.
Organization
Orgcode (PK)
OrgName
OrgAddress
OrgPostcode
OrgContact
OrgTel
OrgFax
OrgEvent
NosExpected
Booking
OrgCode (PK)
BookDate (PK)
Roomno (PK)
Session (PK)
Layoutid
EquipId
Layout
Layoutid (PK)
Description
Equipment
EquipId (PK)
Description
Room
Roomno (PK)
Name (Room Name or Eating area description)
Roomtype (Conf. Or...
All non-key fields must be exclusively dependent on the key field. Over here all tables in 2NF are already in 3NF as follows:
Isolate independent multiple relationships. No table may contain two or more 1:n or n:m relationships that are not directly related. All tables which are in 3NF are already in 4NF except "Booking" table.
Isolate semantically related multiple relationships. There may be practical constraints on information that justify separating logically related many-to-many relationships. All tables in 4NF are already in 5NF except "Room" table.
...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Data base design Essay Example | Topics and Well Written Essays - 1000 words”, n.d.)
Data base design Essay Example | Topics and Well Written Essays - 1000 words. Retrieved from https://studentshare.org/miscellaneous/1530472-data-base-design
(Data Base Design Essay Example | Topics and Well Written Essays - 1000 Words)
Data Base Design Essay Example | Topics and Well Written Essays - 1000 Words. https://studentshare.org/miscellaneous/1530472-data-base-design.
“Data Base Design Essay Example | Topics and Well Written Essays - 1000 Words”, n.d. https://studentshare.org/miscellaneous/1530472-data-base-design.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Data base design

Data Warehouse Design and Implementation

...in this perspective, however hardly any technique exists to date for applying similar methods from an operational database (Charles, 2010; Husemann, Lechtenborger, & Vossen, 2000; Laudon & Laudon, 1999; Inmon, 2002). Without a doubt, there are many standards and methods to implement and design a relational data model for a business system which are flexible to design and implement data warehouse technology based modeling, however they cannot be employed as a natural method, consequently data warehouse development modeling is novel regulation that is improving with the passage of time. Basically, the starting point for the...
10 Pages(2500 words)Research Paper

Data Management Layer Design

...limited to those ones only. Object oriented programming is not supported as well. 3. Object Relational databases Relational databases support specific data formats to overcome these challenge ORDBMS was designed it supports user defined data types. Extended SQL is used to manipulate the data. The important fact is that it is still SQL based hence relational database users do not have to learn another language. It can also handle complex types unlike relational databases. Object oriented is the only perspective in this database and it’s also vendor based where it has not been standardized. 4. Object-oriented databases This database is...
3 Pages(750 words)Coursework

Data base analysis

...? Window server In order to enable the uses in the company network to connect to the internet host s, one has to do the various steps in configuration of the server. The initial step to take is to disable the recursion on the NS3 and NS2 server. This is followed by the enabling the ordering of the netmask on the NS1 server whereas the configuration the NS3 and the NS2 servers to use the NS1 server as a forwarder disabling the round robin on NS1. In disabling this recursion of the server NS2 forces the use and introduction of iterative queries which does not enhance them in resolving the external names (Carvalho, 2012). However, enabling the ordering of the netmask provides the most efficient results for client’s orders... Window server In...
8 Pages(2000 words)Essay

Data Center Design

...Data Center Design Introduction A data center refers to a fault resistant facility that is extremely secured and is used to house telecommunication equipment. The data center facility is designed to facilitate the accommodation of various telecommunication equipment. This equipment include modem racks, switches, and servers among other telecommunication equipment. A data center is used to support functionality of a wide range of tasks. This tasks include hosting web sites, supporting corporate data bases, and other Information and technology services. Basically, a data center of any...
7 Pages(1750 words)Research Paper

Data base

...to add new row in the msflexgrid data and double click the column of each row to enter module code and name, days, time from, time to, room , type and capacity. 3. click the save button if you are finish for that program 4. To open the existing program just click the OPEN BUTTON a search window will appear the select the one of the existing program. Student Maintenance In this system student information are created here and requires every student to register first for personal information and to be used for any emergency purposes. 1. Click the NEW BUTTON then fill up the necessary information in the text box, after you finish the entry click the Save Buttton. 2. To open / edit the...
8 Pages(2000 words)Essay

Data Base Directives

...Data Base Directives Introduction Data is termed as raw fact and figures having indefinite meaning. However if this data is processed, it becomes information. Similarly data organized in a specific manner to give meaningful information is called a Database. With this unmatched advantage of giving meaning to raw data and making it readily accessible, databases have become a necessity for all businesses, students, teacher and even house holds. Intellectual property law always have a special position for the collections of facts. Usually only original or creative expressions were protected under the protection for collections of facts. This...
4 Pages(1000 words)Essay

How a Specification for a Field Will Be Determined

..., “The physical order of the record or field in a table is completely immaterial and each record in a table is identified by a field that contains a unique value” (2003). References Hernandez, Michael, J. (2003). Data base design for mere mortals (2nd Ed.). Boston, MA. Pearson Education, Inc. Nazneen, Cinthia. (2009). ABAP data dictionary. SAP ABAP (ABAP tutorials, notes, ebooks) Retrieved from http://www.abapguide.com/notes/abap-data-dictionary-interview-questions/... field values be handled? Blank or missing fields are those fields where a record does not contain any data. Missing fields can be avoided by introducing compulsory data entry controls, but it is often impossible or undesirable because of...
2 Pages(500 words)Assignment

Data design

...Source document for advertisements coming in to the advertisement company. 2. Suggest at least four user interface design guidelines that could be used for the new system. a. Consistency: There are certain aspects that must be consistent. For instance the interface should be consistent to make the system user friendly and easier to use. The terminology amd the icons should also have a level of consistency between the screens (Fidel Captain. Six-Step Relational Database Design(TM): A step by step approach to relational database design and development Second Edition page 176). b. Simplicity: The system should have the capability to break down complex tasks such that they are reduced to...
2 Pages(500 words)Essay

Database and Data Warehousing Design

...Table of Contents Data Warehouse 2 Rationale Databases and Data Warehouse 2 2.Database Schema 3 2.1Entities Involved In Database Schema: 4 3.Rationale for ER Diagram 7 4. Data Warehouse – Data Flow Diagram (DFD) 1 4.1 Data Flow Diagram Description 0 References 1 Data Warehouse 1. Rationale Databases and Data Warehouse A data warehouse, in the field of Information Technology, is employed to record and evaluate the data to generate significant results. The data warehouse is recognized to assist in incorporating data acquired from a number of...
11 Pages(2750 words)Assignment

Data base

...DMBS product and who manufactures it? IBM DB2 is one of DBMS product and is manufactured by IBM Corporation (Tech-Target). F. What is SQL? Why is it important? It is a standard language used for manipulating and accessing data. One of the importances is that it is used in many organizations to manage their data (SparkNET). G. What does the term, “Database driven Web site”, mean? You will need to use the term “back end database” in your explanation. Database driven website is a website that uses HTML forms to collect data and store them in MYSQL database backend or any other database (Salem). . Works Cited Monash-Research. Top DBMS on Linux | DBMS 2 : Database Management Services....
1 Pages(250 words)Coursework
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 Essay on topic Data base design for FREE!

Contact Us