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.
Nobody downloaded yet

Database Theory and Design - Coursework Example

Comments (0)
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
GRAB THE BEST PAPER
Database Theory and Design
Read TextPreview

Extract of sample
Database Theory and Design

Download file to see previous pages... 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.
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, ...Download file to see next pagesRead More
Comments (0)
Click to create a comment or rate a document
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
Database Design and Implementation
The report starts with the detailed analysis of the requirement, suitable solution for the design and all the assumptions made while designing the model. The ER diagram which visualises the overall operation of ARO is also presented along with a detailed Data dictionary for all the entities defined in the model.
13 Pages(3250 words)Coursework
Analyse and design a small database application based on the given case study
Customers- I obtained the following information from the customers; the customer takes the car to servicing after the computer at car’s dash board notifies him/her that the car should be taken to servicing. The customer can take the car to any nearest branch of Mercedes Company for servicing and he/she expects to be called to come and collect the car after service and given an invoice of all the cost incurred during the service.
12 Pages(3000 words)Coursework
Advanced Marine Design
The following course paper will focus on the initial values that have been used to create an advanced marine vessel that is influenced on dimensional ratios and other aspects of designing the most appropriate type of marine ship. This paper particularly looks into the values that were deployed in the making of a patrol vessel, similar to the 114 USS Varuna.
3 Pages(750 words)Coursework
Database
To enhance the security of the database, several key concepts have to be looked at and properly set. This enhances maximum operation and security of the database. First, the issue of access control should take center stage while discussing the security concepts.
5 Pages(1250 words)Coursework
Course work question in term of report in database field
Silent Cycles has limited database administration to enable them communicate within its 5 branches. They have acknowledged that communication and data sharing between the branches is becoming an ever-growing challenge. They require experts to
7 Pages(1750 words)Coursework
Priori Theory Criminal Justice Research Design
The common issue with qualitative research is credibility which can be established through: peer debriefing, analysis of negative cases, balance and bracketing. In data collection, qualitative researchers can use story telling, shadowing or classical
1 Pages(250 words)Coursework
Organizational Theory and Design Questions
The management consists of a set of individuals who with their best abilities make use of the available resources efficiently. The organizational goals are formulated at a strategic level by the higher management who create the firm’s vision and complement it with
3 Pages(750 words)Coursework
Presentation Outline
In this relational model, tables are used to store and generate the information needed. The process of database design encompasses knowing the target market, gathering the required information from appropriate sources, defining the requirements of the
2 Pages(500 words)Coursework
Database Secuirty
Building managers will have administrator privileges, allowing them to edit and/or update all information pertaining to the building they manage. Tenant information is one of the most crucial facets of
6 Pages(1500 words)Coursework
Let us find you another Coursework on topic Database Theory and Design for FREE!
Contact us:
+16312120006
Contact Us Now
FREE Mobile Apps:
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us