Just fixing Response from Professor from the attached Docx

timer Asked: Apr 22nd, 2017

Question description

don't describe what ERD is, you need to describe Team project's ERD

context diagrams - Level 2 context diagram is actually level 1, I guess Your level 1 I think should be modified.

Surname 1 Name Professor Course Date Entity Relationship Diagram (ERD) This is a graphical representation of a given information system showing the relationship between objects, people, places, concepts within it. This data modelling technique can be helpful in defining business processes. It can also act as the foundation for a relational database (Khoury 2). Normally useful data in an organization is usually represented by a relational structure. However, semi structured or unstructured data sufficiently be represented using an entity relationship diagram. In addition, on its own, an ERD is not helpful in integrating data into a preexisting information system. According to Ling and Pit, an ERD has three components which are the entities. These are concepts or components that can have data stored about them. The relationship between the entities and the cardinally; which defines that relationship in terms of numbers. For instance, an ER diagram representing the information system for a company’s sales department might start with graphical representations of entities such as the sales representative, the customer, their address, the customer’s order, the product and the warehouse. Lines or other symbols can be used to represent the relationship between the entities. Text can be used to label the relationships. Finally, cardinally notations define the attributes or characteristics Surname 2 of the relationship between the entities. Cardinalities can indicate that an entity is optional or compulsory. Three main cardinal relationships are; • One to one (1:1). Example, if each client in a database has one mailing address. • • One to many (1:M). A customer might place an order for a number of products. The client is thus associated with different entities with a single connection back to him or her. • Many to many (M:M). For instance, a company where all call center agents work with multiple customers; each agent is linked with several customers. The multiple customers might also be associated with multiple agents. Entity Relationship Diagram An entity relationship diagram (ERD) illustrates the relationship of the entity sets stored in a database. It is thus the component of the data. In other words it shows the logical structure of databases. At a glance, an ERD resembles a flowchart. However, the symbols and their meaning make it unique. Surname 3 Cited works Khoury, Joe. Qlikview: Entity Relationship Diagrams. , 2017. Internet resource. Ling, Tok W, and Pit K. Teo. A Normal Form Object-Oriented Entity Relationship Diagram. Kent Ridge, Singapore: National University of Singapore, Dept. of Information Systems and Computer Science, 1994. Print. Surname 4 Useful Links http://searchcrm.techtarget.com/definition/entity-relationship-diagram https://www.smartdraw.com/entity-relationship-diagram/ http://www.conceptdraw.com/How-To-Guide/erd-entity-relationship-diagram-symbols https://wcs.smartdraw.com/entity-relationship-diagram/img/erd.jpg?bn=1510011066

Tutor Answer

(Top Tutor) Studypool Tutor
School: Duke University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors