StudentShare
Search
Free

# Draw Entity Relation Database - Essay Example

Summary
In the essay "Draw Entity Relation Database" the author discusses the primary design for the ERD, which comes in action with the various entities that have been identified along with the mapping of such entities with each other with the help of relationships…

## Extract of sample "Draw Entity Relation Database"

A) Given the following table, normalize to 3NF where PK=Primary Key and FK = Foreign Key. Hint: 2nd normal form problem
Part Number (PK)
Warehouse (PK)
Location
At this point, the location attribute is dependent on the Warehouse (PK) only and not on Part Number (PK). It also means that a non-prime attribute is dependent partially on the key attribute, which would fall under the second normal form. After 2NF is normalization the relations would be as follows:
Part Number (PK)
Warehouse (PK)
B) Given the following table, normalize to 3NF where PK=Primary Key and FK = Foreign Key. Hint: transitivity problem
Employee ID (PK)
Dept
Dept Location
At this point, the Dept is dependent on Employee (PK) and Dept Location is dependent on Dept which arises a transitivity problem. It can be solved as follows. Read More
Cite this document
• APA
• MLA
• CHICAGO
(Draw Entity Relation Database Essay Example | Topics and Well Written Essays - 250 words, n.d.)
Draw Entity Relation Database Essay Example | Topics and Well Written Essays - 250 words. https://studentshare.org/education/1528002-draw-entity-relation-database-and-normalization-diagram
(Draw Entity Relation Database Essay Example | Topics and Well Written Essays - 250 Words)
Draw Entity Relation Database Essay Example | Topics and Well Written Essays - 250 Words. https://studentshare.org/education/1528002-draw-entity-relation-database-and-normalization-diagram.
“Draw Entity Relation Database Essay Example | Topics and Well Written Essays - 250 Words”. https://studentshare.org/education/1528002-draw-entity-relation-database-and-normalization-diagram.
Click to create a comment or rate a document

## CHECK THESE SAMPLES OF Draw Entity Relation Database

### Database

... bookings as maximum (cardinality marked as (0, 10) near CLASS/VISIT entity). A booking must always have a class related to it and one class is the maximum (cardinality marked as (1, 1) near BOOKING entity). BOOKING and OWNER An OWNER can have several BOOKINGs and a one BOOKING have a single corresponding OWNER. Hence, one to many relationship exits between these entities (Marked with 1 and M near the respective entity). An OWNER may always have a booking and a booking should always have owner. It is considered a BOOKING and OWNER are mandatory for each other. An OWNER at least has one booking in minimum or many bookings (cardinality marked as (1, M) near OWNER entity). A booking must always have a owner related to it and one owner...
4 Pages(1000 words)Assignment

### Database

In this scenario, IT managers face a lot of challenges in an attempt to bring real business intelligence within time and budget constraints. In the past, when the huge mainframe system empire clasped into a desktop era, IT businesses evolved as well. Additionally, the system storage capacity, processing power, specialized tools and decision-making information were distributed to clients who required freedom of corporate decision making. However, after few years, the pendulum started to shift and with the development of intranets and the Internet connected PC clients formed a networked society that valued information sharing. In this scenario, the IT businesses at the present must develop again. Nowadays they are forced to offer t...
8 Pages(2000 words)Essay

### Database systems-Entity-Relationship modelling

...?Database Systems Entity-Relationship modeling Report Contents Introduction 3 Critical Evaluation 3 The Business rules of the system 3 ER – Model of Lanchester Liners 5 The list of Entities, Attributes, and Relationships of the system 6 Relationships of the system 8 References 9 Introduction This report represents a critical evaluation of the database system initially. The business rules of the system are presented next. The ER- model is designed according to the business rules. Finally the list of key attributes and a list of relationships are provided. Critical Evaluation The implementation of a computerized database will provide several advantages to Lanchester Liners Company. A database will help to make the report generation process...
5 Pages(1250 words)Essay

### Database

This allows or revokes access to the database for authorized users only. It also restricts on the actions that authorized users are allowed to perform on the database. This is the main method of securing data in a database. Access to the database mostly requires correct username and a password which is assigned by the database administrator. The database administrator identifies legitimate users of the database and assigns each a passwords that they use to directly or indirectly access the database for manipulation, retrieval or updating of the data. The second issue that is concerned with database security is database vulnerabilities. Threats from a variety of sources such as internet and users should be identified and minimized...
5 Pages(1250 words)Coursework

### Database

...? Creating an Extended Entity Relationship Model (EERM) Creating an Extended Entity Relationship Model (EERM) We use a classical four-layered approach to inductive specification of database structures. The first layer is the data environment, called the basic data type scheme, which is defined by the system or is the assumed set of available basic data. The second layer is the schema of a given database. The third layer is the database itself representing a state of the application's data often called micro-data. The fourth layer consists of the macro-data that are generated from the micro-data by application of view queries to the micro-data (DIETRICH, 2011). The second layer is diversely treated by database modeling languages...
6 Pages(1500 words)Assignment

### Database

... are held on record. Products are identified by their name and records of the product type and a description of the product are kept. i.) Design an E-R diagram for the above database ii.) Derive a corresponding relational scheme from your E-R diagram. Table Assets: assetID (primary) productID (primary) location LeaseRenewalDate Table Assets Inspection: inspectionID (primary) inspectorID (primary) assetID (primary) maintenanceDate maintenanceAction Table Inspectors: inspectorID (primary) name position Table Products: productID (primary) name type description Question 2: A garden plant supplier keeps data about their customers, orders and the plants they sell in a relational database with the following schema: customer(customer_no {pk...
4 Pages(1000 words)Assignment

...Limited Partnership Individuals can form a limited partnership. The researcher delves into the world of the limited partnership. The research focal point is on the advantages of the limited partnership. The limited partnership thrives best in certain business environments. The limited partnership will thrive best within the locality or community. Denis Clifford (Clifford, 2008) emphasized the partners can contribute funds and/or industry to the local partnership. The partners can share expertise, time, and funds with the aim of generating local revenues. The partnership can generate local revenues with the aim of ensuring net profits crop up during each accounting period. The limited partnership is not subject to federal income... Partnership...
1 Pages(250 words)Essay

...Business Entity Task Introduction Long term financial goals are the goals that a corporation sets to achieve monetary fulfilment through a process of acquiring financial resources (Krus, 2005). This study highlights some long term financial goals, which are cash increase, return increase, and revenue growth. 1. Cash increase Cash increase is a long term goal necessary for the survival of a corporation. This long term goal results to an increase of corporation’s capital. For the target to be considerable and effectual, consequently the goal should be measurable and realistic (Krus, 2005). A measurable goal means that, the corporation can evaluate its achievements. Realistic goal means that set objectives are within reach and can... Entity...
1 Pages(250 words)Essay

### Database

... database to an electronic database and initial training to users before they can use it. Referential integrity is a concept employed in database development that ensures that relationships between tables remain harmonized and consistent. It preserves the relationships previously created between the data tables during the data updates. There exists a connection among all entities in a database via one or more attributes. Applying the referential integrity rules, one ensures that no any change or update that can be effective that affect the relations already defined between tables, Example, no any value of foreign keys can enter the database and does not have a corresponding primary key value in the related table, it also reduces bug...
1 Pages(250 words)Essay