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

Database Theory and Design - Coursework Example

Cite this document
Summary
The consulting company need for developing a database system to computerize its operations management requires that we first decipher the relationships between the different entities involved in its day to day business. The Entity Relationship Diagram obtained is shown…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER98.2% of users find it useful
Database Theory and Design
Read Text Preview

Extract of sample "Database Theory and Design"

The consulting company need for developing a database system to computerize its operations management requires that we first decipher the relationships between the different entities involved in its day to day business. The Entity Relationship Diagram obtained is shown below:Figure 1: Entity Relationship DiagramNote:The entity CONSULTANT inherits JOB_CODE from JOB_CLASSIFICATION as a foreign key.The entity PROJECT inherits CLIENT-ID# as a foreign key from CLIENT because of the 1: M relationship.

Therefore the unique identifier for PROJECT is a combination of CLIENT-ID# and PROJECT_CODE.There is an M: M relationship between CONSULTANT and PROJECT. This leads to the formation of an associative entity, ASSIGNMENT. By virtue of being an associative entity, ASSIGNMENT inherits the primary keys from PROJECT and CONSULTANT which form the composite primary key: CLIENT-ID#, CONSULTANT-ID#.We are also informed that the job classification determines the hourly billing rate therefore ASSIGNMENT will inherit this attribute from JOB_CLASSIFICATION.

Normalization is a formal process for deciding which attributes should be grouped together in a relation (Elmasri & Navathe, 1994). It involves decomposing relations with anomalies to produce smaller, well-structured relations.Three problems usually arise in databases where relations are not normalized. First we could have insertion anomaly, this is where adding new rows forces the user to create duplicate data in the database. Secondly we have modification anomaly, i.e. where changing data in a row forces us to make changes to other rows because of duplication.

Finally we have deletion anomaly which means that when we delete rows we may cause a loss of data that would be needed for other future rows (Connoly & Begg, 2005).First Normal Form (1NF) means that all multi-valued attributes are removed, so that we have a single value at the intersection of each row and column of the relation table. Second Normal Form (2NF) means we apply the rule for 1NF then we remove all partial functional dependencies. Third Normal Form means we apply the rules for 2NF then we remove all transitive dependencies.

From our case we show how we applied normalization rule on the associative entity ASSIGNMENT below:JOB CLASSIFICATION – job-code, description, hourly-rate is 3NF (third normal form)ASSIGNMENT – client-id#, consultant-id#, start-date, work-hours, job-code, rate-per-hour is in 2NF (second normal form). This is because rate-per hour is transitively dependent on job-code. Therefore to make ASSIGNMENT into third normal form (3NF) we remove rate-per-hour from its attributes to end up with ASSIGNMENT – client-id#, consultant-id#, start-date, work-hours, job-code.

ReferencesConnoly, T. M & Begg, C. E. (2005). Database Systems: A practical Approach to Design, Implementation and Management. Harlow: Addison-Wesley.Elmasri, R & Navathe, S. B. (1994). Fundamentals of Database Systems, 2nd ed. Redwood, CA: The Benjamin-Cummings Publishing Co.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Theory and Design Coursework Example | Topics and Well Written Essays - 500 words”, n.d.)
Database Theory and Design Coursework Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/miscellaneous/1567079-database-theory-and-design
(Database Theory and Design Coursework Example | Topics and Well Written Essays - 500 Words)
Database Theory and Design Coursework Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/miscellaneous/1567079-database-theory-and-design.
“Database Theory and Design Coursework Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/miscellaneous/1567079-database-theory-and-design.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Theory and Design

Analysis of Relational Databases and Database Suitability

This theory include relational algebra (which is a set of mathematical operators which operate on relations and produce relation results), relation variables, and relational comparison operators.... A flat database contains only one table.... A database which contains one or several related tables is referred to as a relational database (Harrington, 2002).... In a relational database, symbols are organized into a collection of relations....
4 Pages (1000 words) Essay

Information System Reasarch Project

The properties and design of database systems are incorporated in the curriculum of information technology (1).... In fact, the very basis of computers is a database, which collects all the information fed into it and assembles it into a filing system, which can be retrieved whenever some information related to the subject matter held within its archives is needed.... In fact, any reliable structured source of information can be referred to as a database....
3 Pages (750 words) Article

Relational and Object-Oriented Databases

The paper 'Relational and Object-Oriented Databases' presents database technology which started from flat-file storages and over the years evolved into electronic data storage in the form of records and tables to complete relational and object-oriented databases.... This provides for client-server database architecture which gives a whole new dimension to the existing database structure.... he relational database was a revolution in the field of databases....
8 Pages (2000 words) Case Study

Relational database solution

Your database may require more design and maintenance.... Without a good database design even the best programs cannot avoid problems related to data storage with issues such as the presence of inaccurate and inconsistent data ().... For most business professional having a good relational database design can eliminate such problems and promote the achievement of the objectives of the business organization.... The key to success is in the foundation of the databases design....
2 Pages (500 words) Essay

Managing Business Information

Even so, while defining database, it can be outlined as the prime technique for developing an information system in the modern business process.... The spreadsheets and database are highly used by organisations for proper running of their business.... However, it is noticed that the use of database is preferred against that of spreadsheets, in present business scenario.... The report details the difference between use of database and spreadsheets, along with differences between the two....
5 Pages (1250 words) Assignment

Presentation Outline

Chapter five: Normalization and design Review1.... The process of database design encompasses knowing the target market, gathering the required information from appropriate sources, defining the requirements of the Presentation outline Presentation outline INTRODUCTION I.... Goals of the database design II.... Thesis statement: Database design has become a fundamental part in the development of efficient applications and programs all over the world....
2 Pages (500 words) Coursework

Database Development and Management

The purpose of the paper “Database Development and Management” is to analyze an effective database design that incorporates all the stores product sales and inventories.... The design of a database solution takes up the following structure The database solution contains connectivity of relationships as shown in the key diagram above.... The potential sales information stored within the database entail the price of the product, customer and store number in the store....
12 Pages (3000 words) Term Paper

Establishing Requirements, Low-Fidelity Prototyping and Proposed Data Gathering

nbsp;… Successful completion of any information systems project requires comprehensive requirements analysis, design, implementation, and eventual validation and testing.... This research examines the process of establishing requirements and low fidelity prototyping in the proposed design of MaxiMarket (A shopping mall consisting of 87 outlets) Interactive directory.... The proposed data gathering techniques that will be used to support the final design acceptance will also be given....
10 Pages (2500 words) Case Study
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.
Contact Us