+
CONSIDER A RESEARCH MANAGEMENT SYSTEM IN WHICH FACULTY...

CONSIDER A RESEARCH MANAGEMENT SYSTEM IN WHICH FACULTY...

Rating:
Rating
(0)
Author: Carol 96
Description:

http://theperfecthomework.com/consider-a-research-management-system-in-which-faculty-members-from-different-departments-are-often-collaborated-to-a-research-project-each-faculty-member-is-allocated-with-a-certain-amount-of-research-fund/

CONSIDER A RESEARCH MANAGEMENT SYSTEM IN WHICH FACULTY MEMBERS FROM DIFFERENT DEPARTMENTS ARE OFTEN COLLABORATED TO A RESEARCH PROJECT. EACH FACULTY MEMBER IS ALLOCATED WITH A CERTAIN AMOUNT OF RESEARCH FUND.

Consider a research management system in which faculty members from different departments are often collaborated to a research project. Each faculty memberis allocated with a certain amount of research fund. The following is anexample of an un-normalized RESEARCH-DATA table for two research projects.
   RESEARCH-DATA
Research ID

Research Name

Start Date

Faculty ID

Faculty Name

Research Fund

Department ID

Department Name

1

E-Commerce

04/10/2015

2489

Smith

$200,000

1

ITEC

 
 
 
1887

Jones

$5,000

1

ITEC

 
 
 
9540

Mike

$25,000

5

ISAS

2

Cloud Computing

12/15/2015

3436

Catherine

$200,000

2

BUS

 
 
 
2489

Smith

$10,000

1

ITEC

Perform the normalization process to convert the above un-normalized table to:
1. First normal form (1NF)
2. Second normal form (2NF)
3. Third normal form (3NF)


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial