Hnd Assignment Help Sample
  • July 2, 2017
  • David Marks
  • 0


Entity Relationship Model

TIME TRACKING DATABASE SYSTEMEntity relationship diagram represents the data entities and their association with other data entities in database so that diagram of inter relationship can be used to perform business activities. It gives concept of data arrangement and relations in database development. Al though, ER diagram does not define any operation to perform in business prospective but gives basic idea of data model in which data is arranged to meet business operations. Entities have identification with the attributes.

Components of ER Model

Entity: Smallest and atomic values in database relations are entity which is real world objects. Entities are represented with the help of rectangle diagram. School, mobile, watch etc are example of entities (

Attribute: Entities are identified with their properties which is called attribute. Oval shape in ER diagram represents attributes. Attribute may be of following types:

  • Key attributes: Attribute in database those are capable to identify the entire record form table are key attributes. For example, roll number and mobile number may be key attribute to identify record from tables.
  • Composite attributes: attributes those have composite values in columns are called composite attributes. For example name of student is composite in nature and can be transformed to atomic attributes as first name, middle name and last name.
  • Derived attribute: Attributes those are derived from other attributes are called derived attributes. For example, age can be derived from date of birth column.

Relationship: how to entities are interdependent to other entities in other tables of database are determined with help of relationship diagram. Relationship may exist in three forms:

  • One to one relationship (1:1): In it, one entity of table has relation with other one entity in another table. For example, one monitor in one class is one to one relationship (De
  • One-to-many relationship (1: M): Relationship of one entity with more than one entities in another table is one-to-many relationship. For example, one class can contain more than one student.

David Marks

Dear sir/Ma'am

Our dedication and hard work towards developing quality content has made us competent to provide excellent services to the clients as per their needs. We ensure plagiarism free writing obeying academic integrity and honesty making us a dedicated team towards developing original content helping students to ensure high grades. Our services are hassle free, timely yet at an affordable rate driving clients to avail it for a longer period of time making them loyal and satisfied towards us.

Services we offer:
Essay writing
Report writing
Assignment writing
Reflective writing
Proposal writing
Dissertation writing
Thesis writing
CDR writing
Annotated bibliography
PowerPoint presentation
Article/book review
Why us?
Plagiarism free original content
On-time services maintaining deadlines
Experienced writers
Plagiarism and Grammarly report
Dedicate Team Leaders and Quality Checkers
Subjects we cover:
Marketing management
Human resource management
Environmental science
Business studies
Political science
Journalism and Masscommunication

Declaration: Working with us will give you the opportunity to avail divergent range of academic services at affordable rates in assistance with the dedicated team having members from different disciplines holding high degrees in their respective domains. We are experienced in developing B-plan, writing dissertations and theses having employed highly qualified and experienced writers.

You can reach us at-
Oz Paper Help
1 Step 1