High-quality custom papers starting from $10/page

  • All papers written from scratch
  • We hire professional writers only
  • Original and creative work
  • Timely delivery guaranteed
  • Variety of disciplines, topics, and deadlines
  • 100% confidentiality guarantee
Order Now Get Free Quote

Welcome to our EssayLib.com Blog!

On our blog you will find a lot of useful tips and advice from professional academic writers, along with the specific examples of their writing. Here you may read various sample research papers and case studies, theses and dissertations, essays and reviews. All the sample papers we post on our blog may only serve as an example for our visitors and cannot be submitted as their own work, since this will result in plagiarism accusations. However, if you like a certain paper and would like to order a similar one on your specific topic – do not hesitate to place an order on our website and have your paper completed from scratch by our professional PhD and Master's degree holding writers.

31Aug

Research Paper on Database Management

Posted by admin as Example papers

Research Paper on Database Management

Database/IT
1
Various advantages have been identified with regard to the utilization of relational databases and the same will be quite notable within your organization. The first advantage concerns the elimination of information redundancy. The organization clearly bears a lot of information that may be replicated with regard to manual filing processes due to the large information size. Therefore, using the database, it becomes easier to arrange information and ensure that replication does not occur. Secondly, information grouping propels the company into enhanced information management through the associations created amongst the various variables. Thirdly, the database enhances communication since the information is easily shared across internal networks thereby ensuring that any modification noted within a given branch is ultimately reflected within the other branches on a real-time basis. This overcomes the spatial aspect noted with manual filing. Fourthly, through enhanced management across the given branches, trade effectuality is created and consequently profit and proceeds. The fifth benefit is that individuals bearing access to the database are able to conduct statistical analyses that aid with factors such as graphs to aid with information comprehension and synthesis. This will be advantageous in areas like appraisals of the working systems in determining whether optimality is noted within the diverse workforce. Lastly, enhanced information distribution creates flexibility within the organization thus creates working efficacies through time saving practices. The given duration can then be averted to other beneficial activities.
(b) The diagram below is representative of the three-level database as defined by the ANSI/SPARC architecture. The assumption made in diagram creation is that the given attributes act as the only measurable factors within the organization:

The diagrams represented in the diagrams in task 2(a) show the external view of users. Since the user are from different sectors operating on the same kind of data, they can be termed as multiple users. This means that the diagrams fall in external level of the ANSI-SPARC architecture.

(c)
Task 3

b)

This Entity relationship diagram represents the conceptual level of the ANSI-SPARC architecture.

(c)

Local users identifiable within the given diagram can clearly be noted as employees, customers, government agencies and outside shops. They are related to at least one attribute in the same relational database.

Task 4

(a)

The following relationships are derived from the entity relationship diagram.

Employees (ID, Position, Basic Salary, Name, Mobile Number, Address)

Location (Location ID, Location Name, Trading Hours, Description, Manager, Address, Phone)

Commission on Values (Commission ID, 6% for up to $4,000, 5% for $4,000 to $6, 000, 4% for $6,000 to $8, 000, 3% for above $8, 000)

Sales (Sales ID, Commission ID, Sales Amount, Commission Paid, Sales Date)

Vehicle(Registration Number, Model, Purchase Price, Colour, Make, VIN, Number of owners, Size of Engine, Year of Manufacture, Odometer Number, Asking Price, Minimum selling price, Other features Extras)

Factors Considered (Factors ID, Repair Costs, Registration Expiry Date, Government Requirements and Inspector Information)

Responsibilities (Responsibility ID, Generate Invoices, Wash Cars, Repair Vehicles)

Required Information (Info ID, Employee ID, Name, Salary, Position, Address, Most Relevant Qualification, Description, Mobile Number)

ID-> Position, Basic Salary, Name, Mobile Number, Address

Location ID -> Location Name, Trading Hours, Description, Manager, Address, Phone

Commission ID ->6% for up to $4,000, 5% for $4,000 to $6, 000, 4% for $6,000 to $8, 000, 3% for above $8, 000

Sales ID -> Commission ID, Sales Amount, Commission Paid, Sales Date

Registration Number -> Model, Purchase Price, Colour, Make, VIN, Number of owners, Size of Engine, Year of Manufacture, Odometer Number, Asking Price, Minimum selling price, Other features Extras

Factors ID -> Repair Costs, Registration Expiry Date, Government Requirements and Inspector Information

Responsibility ID -> Generate Invoices, Wash Cars, Repair Vehicles

Info ID -> Employee ID, Name, Salary, Position, Address, Most Relevant Qualification, Description, Mobile Number

(b)

To change the relationship from 1NF to 2NF then to 3NF, partial key dependencies and transitive dependencies have to be removed

Employees (ID, Position, Basic Salary, Name, Mobile Number, Address)

ID-> Position, Basic Salary, Name, Mobile Number, Address

ID -> Name, Mobile Number, Address

Position -> Basic Salary, ID

Location (Location ID, Location Name, Trading Hours, Description, Manager, Address, Phone)

Location ID -> Location Name, Trading Hours, Description, Manager, Address, Phone

Location ID -> Location Name, Description, Trading Hours, Manager

Manager -> Address, Phone

Commission on Values (Commission ID, Commission Paid)

Commission ID ->6% for up to $4,000, 5% for $4,000 to $6, 000, 4% for $6,000 to $8, 000, 3% for above $8, 000

This can be left as is.

Sales (Sales ID, Commission ID, Sales Amount, Commission Paid, Sales Date)

Sales ID -> Commission ID, Sales Amount, Commission Paid, Sales Date

Sales ID -> Sales Amount, Sales Date, Commission ID

Commission ID -> Commission Paid

Vehicle(Registration Number, Model, Purchase Price, Colour, Make, VIN, Number of owners, Size of Engine, Year of Manufacture, Odometer Number, Asking Price, Minimum selling price, Other features Extras)

Registration Number -> Model, Purchase Price, Colour, Make, VIN, Number of owners, Size of Engine, Year of Manufacture, Odometer Number, Asking Price, Minimum selling price, Other features Extras

Registration Number -> Model,

Model -> Purchase Price, Colour, Make, VIN, Number of owners, Size of Engine, Year of Manufacture, Odometer Number, Asking Price, Minimum selling price, Other features Extras

Factors Considered (Factors ID, Repair Costs, Registration Expiry Date, Government Requirements and Inspector Information)

Factors ID -> Repair Costs, Registration Expiry Date, Government Requirements and Inspector Information

This will remain as it is because it is already in the BCNF

Responsibilities (Responsibility ID, Generate Invoices, Wash Cars, Repair Vehicles)

Responsibility ID -> Generate Invoices, Wash Cars, Repair Vehicles

This will also remain as it is because is already in BCNF

Required Information (Info ID, Employee ID, Name, Salary, Position, Address, Most Relevant Qualification, Description, Mobile Number)

Info ID -> Employee ID, Name, Salary, Position, Address, Most Relevant Qualification, Description, Mobile Number

Info ID -> Employee ID

Employee ID -> Mobile Number, Name, Salary, Position, Address, Most Relevant Qualification, Description

The BCNF obtained from the relationships is as shown below:

Employee (ID, Name, Mobile Number, Address)

Position (Position, Basic Salary, ID)

Location (Location ID, Location Name, Description, Trading Hours, Manager)

Manager (Manager, Address, Phone, Location ID)

Commission on Values (Commission ID, Commission Paid)

Sales (Sales ID, Sales Amount, Sales Date, Commission ID)

Commission (Commission ID, Commission Paid)

Vehicle (Registration Number, Model)

Model (Model, Purchase Price, Colour, Make, VIN, Number of owners, Size of Engine, Year of Manufacture, Odometer Number, Asking Price, Minimum selling price, Other features Extras)

Factors Considered (FactorsID, Repair Costs, Registration Expiry Date, Government Requirements and Inspector Information)

Responsibilities (ResponsibilityID, Generate Invoices, Wash Cars, Repair Vehicles)

Registration Information (Info ID, Employee ID)

Issue Information (Employee ID, Mobile Number, Name, Salary, Position, Address, Most Relevant Qualification, Description)

(c)

Employees (ID, Position, Basic Salary, Name, Mobile Number, Address)

PK ID

AK Mobile Number

SK Name

Position (Position, Basic Salary, ID)

PK Position

SK ID => Employees

Location (Location ID, Location Name, Trading Hours, Description)

PK Location ID

SK Name

FK Phone => Employees

Manager (Manager, Address, Phone, Location ID)

PK Manager

SK Location ID => Location

Commission on Values (Commission ID, Commission Paid)

PK Commission ID

Sales (Sales ID, Commission ID, Sales Amount, Sales Date)

PK Sales ID

AK Commission ID

FK Commission ID => Commission on value

Vehicle (Registration Number, Model)

PK Registration Number

SK Model

Model (Model, Purchase Price, Colour, Make, VIN, Number of owners, Size of Engine, Year of Manufacture, Odometer Number, Asking Price, Minimum selling price, Other features Extras)

PK Model

AK Odometer Number

Factors Considered (Factors ID, Repair Costs, Registration Expiry Date, Government Requirements and Inspector Information)

PK Factors ID

Responsibilities (Responsibility ID, Generate Invoices, Wash Cars, Repair Vehicles)

PK Responsibility ID

Required Information (Info ID, Employee ID)

PK Info ID

FK Employee ID => Issue Information

Issue Information (Employee ID, Mobile Number, Name, Salary, Position, Address, Most Relevant Qualification, Description)

PK Employee ID

AK Mobile Number

Comments are closed.

Free Plagiarism Checker

If you want to check your text for plagiarism click here

Safety & Confidence

McAfee SECURE sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
TRUSTe online privacy certification

Hot Prices

Custom Paper Features

  • Approx. 275 words / page
  • Font: 12 point Arial
  • Double line spacing
  • Any citation style
  • Free bibliography page
  • Free title page
  • Free table of contents
  • Free revisions according
    to our Revision Policy
  • Fully referenced work
  • We write on any topics