Essay Entity Relation Diagram

Words: 3556
Pages: 15
Open Document
Contents ERD (Entity Relation Diagram) 2 2.1 History of ERD 2 2.2 Building Blocks 2 2.2.2 Relationship 2 2.3. Diagramming Conventions 3 MS ACESS TABLE 5 3.1 Parts of Table 6 3.2 Creating Tables in Access 6

Chapter No 2
ERD (Entity Relation Diagram)
2.1 History of ERD
An entity-relationship model (ERM) is an abstract and conceptual representation of data. Entity-relationship modeling is a database modeling method, used to produce a type of conceptual schema or semantic data model of a system, often a relational database, and its requirements in a top-down fashion. Diagrams created by this process are called entity-relationship diagrams, ER diagrams, or ERDs.
This technique was developed by PETER CHEN in 1976 since …show more content…
It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. In mid-May 2010, the current version of Microsoft Access 2010 was released by Microsoft in Office 2010; Microsoft Office Access 2007 was the prior version. In databases for storing data in the Microsoft Access first we store data in tabular form. All data in a relational database is stored in tables. Create table in design view is a simple yet best way to enter the data into the table.
A table in Access is quite different then a table in real life. Instead of having wooden legs and being used for meals, Access Tables are a grid made up of rows and columns. Here's an example of a table in Access:

There are for key components we want you to learn right now: 1. tbl_Sales: The name of our table is the example is "tbl_Sales". Note that we could have simply called our sales table Sales, but by including a prefix tbl_ there is absolutely no confusion and is a great Access habit to pick up! 2. Columns: A column is one vertical section of the table (i.e. up-and-down sections). The vertical columns have their label at the top and these labels should describe the type of information that will be stored. The columns in this table are: Employee, Product, Price and Sale Number. 3. Rows: A row is one horizontal segment of the table (i.e. left-to-right sections). One record takes up exactly one row. For example, in this table one
Show More

Related Documents: Essay Entity Relation Diagram

To Add To Your Talk About Email Which Is An Easy Example Of Unstructured Data

extract the necessary elements. 4. An Entity Relationship Diagram is a snapshot of data structures. An Entity Relationship Diagram shows entities or tables in a database and relationships between tables within that database. For a good database design it is pretty much essential to have an Entity Relationship Diagram. There are three basic elements in an Entity Relationship Diagram; 1. Entities are the "things" for which we want to store information. An entity can be a person, place, thing or event…

Words 586 - Pages 3

Database and Spreadsheet Essay

105065-83@stu.ctlondon.ac.uk Submitted to: Dr. Jin Wu | Table of Content 1.0 Introduction: 3 2.0 Database Elements 3 2.1 Queries 3 2.2 Reports 4 2.3 Attributes 4 3.0 Standard Approaches of DB Design: 4 3.1 Entity – Relationship Diagram: 4 1) Entity 4 2) Primary Key 4 3) Relational Database 5 4.0 Table Structures 7 4.1 Patient Table 7 4.2 Booking 8 4.3 Therapist 8 4.4 Therapy Type 10 5.0 Conclusion 11 6.0 References 12…

Words 1717 - Pages 7

It Sql Final Essay

(column1,column2,column3,...) VALUES (value1,value2,value3,...); UPDATE: The UPDATE statement is used to update existing records in a table. DELETE: The DELETE statement is used to delete rows in a table. How do you drag a Relationship within a diagram? You drag a Relationship from the higher end to the Parent table and the other end to the Child table. What are the 2 Database parts? DDL: Data Definition Language and DML: Data Manipulation Language What action does Select * perform? The SELECT…

Words 2049 - Pages 9

Data Management and Decision Making Essay

of related files – File: Group of records of same type – Record: Group of related fields – Field: Group of characters as word(s) or number • Describes an entity (person, place, thing on which we store information) • Attribute: Each characteristic, or quality, describing entity – Example: Attributes DATE or GRADE belong to entity COURSE 4 The data hierarchy A computer system organizes data in a hierarchy that starts with the bit, which represents either a 0 or a 1. Bits can be…

Words 2085 - Pages 9

Cs251 Fundamantals of Database Systems Ip 1 - 5 Essay

CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks…

Words 1684 - Pages 7

A Brief Note On The USM Material Requirement Planning System

conducted interviews, gathered information from questionnaires. Project team also performed gap analysis between current and expected system. Based on the requirements, a process model was developed using DFDs, and a data model is developed using entity-relation diagrams. Obligatory and non-obligatory analysis was conducted and a final database was designed using MS-Access. Tables, forms, reports and queries were built in access. Once final database is developed, it was thoroughly tested using test procedures…

Words 8945 - Pages 36

Data Are Raw Facts That Has Meaning

(pg. 32) 3. a noun in a business rule will translate into an entity in the model, and a verb associating nouns will translate into a relationship among the entities. 4. DML and DLL emerged to standardize the basic data model. It allowed for the conception of the schema and subschema. (pg. 36) 5. Basic features use an analogy, the relational model produced…

Words 1002 - Pages 5

Database management system Essay

systems (DBMS) Database = set of relations (or tables) – Each relation in the database has a distinct name – Example: Student, Campus • Each relation has a set of attributes – Each attribute has a distinct name, used to describe the entities in the relation – Example: Students have FirstName, LastName, ID, SS#, etc. • Tuple has a value for each attribute, representing a single entity – Example: Each student in the class is a tuple – An specific entity, Brian • Each attribute…

Words 875 - Pages 4

The Systematic Study And Application Of Knowledge About How Individuals And Groups Act Within The Organization

learner- one whip processes information most effectively by looking at words and diagrams +auditory Learner-one who process information most effectively by listening or talking +kinesthetic leaner- one who process information most effectively by actively engaging with the material +hypotheses- tentative guesses or hunches for an expected observation, phenomenon or scientific problem that can be tested +variables- entities that can take on different values +Surveys- research tools used to explicit…

Words 547 - Pages 3

Database System Concepts Essay example

Chapter 1: Introduction Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See www.db­book.com for conditions on re­use Database Management System (DBMS)  DBMS contains information about a particular enterprise  Collection of interrelated data  Set of programs to access the data  An environment that is both convenient and efficient to use  Database Applications:  Banking: transactions  Airlines: reservations, schedules  Universities: registration, grades…

Words 1215 - Pages 5