country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

ITECH 1006 Database Management Systems For First Normal Form

tag 0 Download6 Pages / 1,337 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: ITECH 1006
  • University: Federation University
  • Country: Australia

Questions:

1. Design a relational database for a provided scenario utilising tools and techniques including ER diagrams, relation models and normalisation
2. Describe relational algebra and its relationship to Structured Query Language (SQL);
3. Design and implement a relational database using a database management system;

 

Answer:

Assumptions

During the development of ERD the assumptions those have been made are as follows:

  1. Between the start and end date of the project the payment should be done by the payee.
  2. The project could have different types of clients
  3. Various payments are also available for one project
  4. Non staff member can also be the lead of the project  
 

Normalization

First Normal form: Each entity associated to the table must have an atomic value to be in first normal form. The database does not have any multivalued attribute which reflects that it is in first normal form.

Staff_Member

S_ID

S_FName

S_LName

S_PhNumber

S_Address

S_Email

S_TNumber

S_JobTitle

S_WeeklyRateOfPay

StartDate

EndDate

Notes

 

Client

ClientID

FirstName

LastName

PhoneNumber

address

contact_name

ClientTypeID

Name

Description

ProjectID

StartDate

EndDate

Notes

 

ProjectLead

LeadID

Name

Email

 

Document

DocID

DocuentTitle

AuthorName

TypeID

Type

TypeDescription

 

Project

ProjectID

Name

Description

StartDate

EndDate

Progress

TypicalProjectValue

ExpenseID

ExpenseAmount

ExpenseDate

ExpensePayee

ExpenseDescription

PaymentID

PaymentAmount

PaymentDate

ClientReferenceNumber

GovernmentDepartmentName

GovernmentContactNumber

DonorName

DonorAddress

DonorEmial

 

Second Normal form: Following are the rules that must be possessed by the second normal form:

  1. The table must be in 1stnormal form
  2. No such nonprime attribute are to be dependent on the subset of any of the candidate key placed in the tables

Staff_Member

FirstName

LastName

PhoneNumber

address

email

TaxNumber

JobTitle

WeeklyRateOfPay

 

Staff_Work

ProjectName

StartDate

EndDate

Notes

 

The StartDate, EndDate and the notes are not dependent on the primary attributes but on the project name. However, the project name is not the proper subset of the primary key.  

Client

FirstName

LastName

PhoneNumber

address

contact_name

client_type

description

 

client_project

ProjectName

StartDate

EndDate

Notes

 

ProjectLead

name

email

 

Document

DocuentTitle

AuthorName

type

TypeDescription

Project

name

description

StartDate

EndDate

progress

TypicalProjectValue

ExpenseAmount

ExpenseDate

ExpensePayee

ExpenseDescription

PaymentAmount

payment_date

ClientReferenceNumber

GovernmentDepartmentName

GovernmentContactNumber

DonorName

DonorAddress

DonorEmial

 

Third Normal form: The following are the rules to be in third normal form:

  1. The table must have to be second normal form
  2. In case of non-trivial functional dependency, X→A, where A is the primary attribute and X is the superkey.

 

Document

DocID

TypeID

DocuentTitle

AuthorName

 

Document_Type

TypeID

Name

Description

 

Project

ProjectID

Name

Description

StartDate

EndDate

Progress

TypicalProjectValue

 

Expense

ExpenseID

Amount

Date

Payee

Description

 

ClientPayment

PaymentID

ProjectID

ReferenceNumber

Amount

Date

 

Government_Payment

PaymentID

ProjectID

GovernmentDepartmentName

ContactNumber

Amount

Date

 

donation

PaymentID

ProjectID

Amount

Date

Relational Schema

StaffMember

Attribute

Type

Purpose

Validation

Key

S_ID

Varchar

Unique identification of rows in the table

No two rows can be same

Primary

S_FName

Varchar

The first name of the staff

 

None

S_LName

Varchar

The last name of the staff

 

None

S_PhNumber

Number

The phone number of the staff

Must be of ten numbers

None

S_Address

Varchar

The address of the staff

 

None

S_Email

Varchar

The email of the staff

Should have  a valid mail id

None

S_TNumber

Number

The tax number of the staff

 

None

S_JobTitle

Varchar

Staff designation

 

None

S_WeeklyRateOfPay

Numeric (4,2)

Payment done to staff per week

 

None

 

Client

Attribute

Type

Purpose

Validation

Key

C_ID

Varchar

Unique identification of rows in the table

No two rows can be same

Primary

C_TypeID

Varchar

Indicates to the primary key of Client_Type entity

Must be same with one of the primary keys of Client_Type entity

Foreign

C_FName

Varchar

The first name of the client

 

None

C_LName

Varchar

The last name of the client

 

None

C_PhNumber

Number

The phone number of the client

Must be of ten numbers

None

C_Address

Varchar

The address of the client

 

None

C_ContctName

Varchar

The name of the (only for contact) of the client

 

None

 

Project

Attribute

Type

Purpose

Validation

Key

Proj_ID

Varchar

Unique identification of rows in the table

No two rows can be same

Primary

P_Name

Varchar

The name of the project

 

None

P_Description

Varchar

Description of the project

 

None

Start_Date

Date

Start date of the project

Must be of ten numbers

None

End_Date

Date

End date of the project

Should be bigger than StartDate

None

P_Progress

Varchar

The name of the (only for contact) of the client

 

None

TypicalProjectValue

Varchar

The typical value of the project

 

None

 

ProjectLead

Attribute

Type

Purpose

Validation

Key

Lead_ID

Varchar

Unique identification of rows in the table

No two rows can be same

Primary

Proj_ID

Varchar

Indicates to the primary key of project entity

Must be same with one of the primary keys of PROJECT entity

Foreign

Name

Varchar

Name of the project lead

 

None

Email

Varchar

Email of the project lead

Should have  a valid mail id

None

 

Document

Attribute

Type

Purpose

Validation

Key

Doc_ID

Varchar

Unique identification of rows in the table

No two rows can be same

Primary

TypeID

Varchar

Indicates to the primary key of Document_Type entity

Must be same with one of the primary keys of Document_Type entity

Foreign

DocuentTitle

Varchar

Name of the document

 

None

AuthorName

Varchar

The name of the author of document

Should have  a valid mail id

None

 

Payment

Attribute

Type

Purpose

Validation

Key

Pay_ID

Varchar

Unique identification of rows in the table

No two rows can be same

Primary

ProjID

Varchar

Indicates to the primary key of project entity

Must be same with one of the primary keys of PROJECT entity

Foreign

Amount

Varchar

Reference number of client

 

None

Date

Numeric (10,2)

Amount paid by client

 

None

date

Date

Date of payment

Must be within project start date and end date

None

 

Government_Payment

Attribute

Type

Purpose

Validation

Key

Pay_ID

Varchar

Unique identification of rows in the table

No two rows can be same

Primary

project_ID

Varchar

Indicates to the primary key of project entity

Must be same with one of the primary keys of PROJECT entity

Foreign

GovernmentDepartmentName

Varchar

Name of the department that paid amount

 

None

ContactNumber

Number

The contact number of the department

Must be of ten numbers

None

Amount

Numeric (10,2)

Amount paid by client

 

None

Date

Date

Date of payment

Must be within project start date and end date

None

 

donation

Attribute

Type

Purpose

Validation

Key

Pay_ID

Varchar

Unique identification of rows in the table

No two rows can be same

Primary

project_ID

Varchar

Indicates to the primary key of project entity

Must be same with one of the primary keys of PROJECT entity

Foreign

DonorName

Varchar

Name of the donor

 

None

Address

Number

The address of the donor

Must be of ten numbers

None

Email

Varchar

The email of the donor

Should have  a valid mail id

None

Amount

Numeric (10,2)

Amount paid by client

 

None

Date

Date

Date of payment

Must be within project start date and end date

None

 

 

Bibliography

Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management. Cengage Learning.

Elmasri, R. and Navathe, S.B., 2015. Fundamentals of database systems. Pearson.

Gouhar, A., 2017. Database Management System. International Journal of Engineering Science, 11766.

Kadam, M., Jidge, P., Tambe, S., Tayade, E. and Bhusari, V., 2014. Cloud Database Management System (CDBMS). International Journal Of Scientific Research And Education, Monica Kadam et al. IJSRE, 2(3), pp.414-420.

Nidzwetzki, J.K. and Güting, R.H., 2016. DISTRIBUTED SECONDO: An extensible highly available and scalable database management system. FernUniversität, Fakultät für Mathematik und Informatik.

Patil, S.K. and Bhagate, S.B., 2017. Protecting Data in Relational Database Management System using Purpose and Role-Based Access Control.

Singer, M., 2016, June. The application of a database management system in an energy management system. In Proceedings of the Ninth Power Systems Computation Conference (p. 359). Elsevier.

Zhang, N. and Song, W., 2016. Database Design on Construction Project Cost System.

Download Sample

Get 100% money back after download, simply upload your unique content* of similar no. of pages or more. We verify your content and once successfully verified 100% value credited to your wallet within 7 days.

Upload Unique Document

Document Under Evaluation

Get Credits into Your Wallet

*The content must not be available online or in our existing Database to qualify as unique.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Database Management Systems For First Normal Form. Retrieved from https://myassignmenthelp.com/free-samples/itech-1006-database-management-systems-for-first-normal-form.

"Database Management Systems For First Normal Form." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/itech-1006-database-management-systems-for-first-normal-form.

My Assignment Help (2020) Database Management Systems For First Normal Form [Online]. Available from: https://myassignmenthelp.com/free-samples/itech-1006-database-management-systems-for-first-normal-form
[Accessed 10 July 2020].

My Assignment Help. 'Database Management Systems For First Normal Form' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/itech-1006-database-management-systems-for-first-normal-form> accessed 10 July 2020.

My Assignment Help. Database Management Systems For First Normal Form [Internet]. My Assignment Help. 2020 [cited 10 July 2020]. Available from: https://myassignmenthelp.com/free-samples/itech-1006-database-management-systems-for-first-normal-form.


For years now, MyAssignmenthelp.com is providing affordable essay help to millions of students worldwide. Our essay assistance services have helped us in assisting students with even the toughest essay assignments. We take pride in the fact that we cater the best assistance to search terms like help me with my essay. We offer affordable services in the fastest way possible. For our fast delivering services, students trust us with their urgent essay assignment needs. Two of our most popular essay writing services are maths essay help and English essay help.

Latest Management Samples

DMKT5008 Digital Marketing Spring

Download : 0 | Pages : 21

Answer: Introduction The whole study is focussed on the importance of digital marketing in nowadays. The importance is being felt by one of the renowned names in the entertainment industry. It is about HMV which is headquartered in the UK. The company had remained a popular name in the entertainment industry until the time; the position was actually being hampered by Amazon in around 2012. Amazon had enabled people getting their favourite mus...

Read More arrow

IHRM4032 Introduction To Human Resource Management Spring 2018

Download : 0 | Pages : 12

Answer: Introduction Management of human resources of an organization is pivotal to the success of the organization. Human resource management team plays a wide variety of roles in the business starting from recruiting competent employees, ensuring the employees are fairly compensated, putting efforts in retaining employees, managing organizational talent and addressing employee grievances (Jackson, Schuler & Jiang, 2014). The case in the...

Read More arrow Tags: Australia Marlborough Management University of New South Wales Humanities 

FELM4026 Financial And Economic Literacy For Managers11

Download : 0 | Pages : 20

Answer: Introduction: The financial and economic literacy report has been prepared to analyze and evaluate the numerous concepts about the economical concept, micro factors, macro factors etc. the report explains about the changes and the performance of UK economical position. For preparing the report, local high street market of UK has been evaluated and it has been identified that how the corporate could growth itself. Further, the study ha...

Read More arrow

FELM4026 Financial And Economic Literacy For Managers11

Download : 0 | Pages : 20

Answer: Introduction: The financial and economic literacy report has been prepared to analyze and evaluate the numerous concepts about the economical concept, micro factors, macro factors etc. the report explains about the changes and the performance of UK economical position. For preparing the report, local high street market of UK has been evaluated and it has been identified that how the corporate could growth itself. Further, the study ha...

Read More arrow

DMKT5008 Digital Marketing Spring 2018

Download : 0 | Pages : 21

Answer: Study background:   The whole study is focussed on the importance of digital marketing in nowadays. The importance is being felt by one of the renowned names in the entertainment industry. It is about HMV which is headquartered in the UK. The company had remained a popular name in the entertainment industry until the time; the position was actually being hampered by Amazon in around 2012. Amazon had enabled people getting th...

Read More arrow
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,359,015

Orders

4.9/5

Overall Rating

5,081

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

154 Order Completed

97% Response Time

Harold Alderete

PhD in Economics

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 4/5

248 Order Completed

100% Response Time

Lloyd Bernabe

MSc in Accounting

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

798 Order Completed

97% Response Time

Benjamin Blakeman

MSc in Medical Technology

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1592 Order Completed

96% Response Time

Jane Sima

Ph.D in Psychology with Specialization in Industrial-Organizational Psychology

Singapore, Singapore

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Great work from expert! All good just missing one 1 reference, feedback and get it within a few hours.

flag

User Id: 254651 - 10 Jul 2020

Australia

student rating student rating student rating student rating student rating

Amazing work, thank you very much I have achieved amazing results. Thank you for your hard work

flag

User Id: 261191 - 10 Jul 2020

Australia

student rating student rating student rating student rating student rating

Really good work on the code. It ran perfectly and there were no mistakes in the code. All of the instructions were followed and there were no syntax errors at all.

flag

User Id: 457776 - 10 Jul 2020

Australia

student rating student rating student rating student rating student rating

very clear answers, full of information. The doctor was very happy with the answers. Thank you.

flag

User Id: 391476 - 10 Jul 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?