+91-9519066910
USA: +1(585)6662225, IN: +91-7503070001, IN:+91-9519066910

Assignment

Computing Skills Assignment Help

Matlab Assignment Help

Database design concept

Rating:
Database design concept

 Database design concept

 

Task 2

2.1 Analyze a database developmental methodology

A database development methodology is effective to facilitate the developers in planning, modelling and managing the database development process. It can help to achieve the systematic and structured execution with validation of the data and stages. The methodology for the development has consideration of mainly three processes: conceptual, logical and physical modelling of the data.

Conceptual database design methodology  

During the methodology, the conceptual model can be prepared with the declaration and definition of the entities, attributes and constraints whereas entity types can be defined to ensure the effective conceptual design with data accuracy. Also, relationship, type of the relationship, associated attributes, and keys are determined. At last, the conceptual model is validated and reviewed for the accuracy and redundancy issues.

Logical database design methodology  

During the process, the logical design is prepared with validated conceptual model. Relations are derived through the programming language and validated for the normalization process. Also, user transactions, and integrity constraints are checked (Ambler, 2012). It has effective integration of the users in the logical design of the system for the organization. However, it is the structure of the database system without the need of data.

Physical database design methodology  

Base tables are created at this process and derived data are presented. Also, business rules, file organization, and indexes are prepared. The organization can analyze the transactions and need of storage and on that basis; user views and security mechanisms can be designed. The outcome of the process is the implementable solution for the organization.

2.2 Discuss entity-relationship modelling and normalization

Entity-relationship model is used to present the relationship between the entities in the database system whereas entities are objects having information. Therefore, entities are concepts having relevancy to the database. For example, there are four departments in each company and each employee has relationship with one department only. Therefore, there are mainly four entities including employee, department and company and dependents.

Relationship is used to link the tables for their association. For example, one employee is related to one department which represents one-to-one relationship. Also, one department can contain one or more employees; it is one-to-many relationship (Thalheim, 2013). Also, the dependents of the employees might be zero or many which represents the relationship of many-to-many.

Attributes are used to define the entities. For example, the name, contact details, department name and other details associated with the employee entity are the attributes. The attribute which can define the rows or record uniquely is a key. A primary key is not null and unique key for the table. Employee dependents can be presented with the help of multi-valued attribute as one employee might have multiple dependents.



 DOWNLOAD SAMPLE ANSWER

Details

  • Number of views:
    351
  • PRICE :
    AU$ 350.00

Submit Works

Urgent Assignment Help

Our Top Experts


Karen Betty

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders


Daphne Lip

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders


Mr Roberto Tuzii

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders


Harsh Gupta

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders


ARNAB BANERJEE

JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders


KARAN BHANDARI

Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders


Tan Kumar Ali

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders


Wesenu Irko

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders


Lizzy Darley

I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi...

109 - Completed Orders


CRYSTAL

HSC PREPARATION I specialise in English coaching programs for HSC students. My personalised and results-...

202 - Completed Orders