Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a simple list table of a company trying to keep track of employee assignment to company projects (in other words, not a database

This is a simple list table of a company trying to keep track of employee assignment to company projects (in other words, not a database but a flat one table file). You will design a database for this company so that they won?t be relying on a simple 1 table list system to keep track of their data. Looking at the table below, identify the separate entities and attributes and design a physical level Entity Relationship Diagram for this company.

Project Project Name Code PC010 Reservation System PC010 Reservation System Reservation System PC011 HR System PC011 HR System HR System PC011 PC012 Attendance PC010 System PC012 Attendance PC012 System Attendance System Project Project Employee Employee Department Manager Budget No. Name No. 120500 $100 Mr. Ajay Mr. Ajay Mr. Ajay Mrs. Charu Mrs. Charu Mrs. Charu Mr. Rajesh Mr. Rajesh Mr. Rajesh 120500 $101 120500 $102 500500 $103 500500 $104 500500 $315 710700 $137 710700 $218 710700 $109 Mohan Vipul Riyaz Pavan Jitendra Pooja Rahul Avneesh Vikas D03 D02 D01 D03 D02 D01 D03 D02 D01 Department Hourly Name Rate Database 21.00 Testing IT Database Testing IT Database Testing IT 16.50 22.00 18.50 17.00 23.50 21.50 15.50 20.50

Step by Step Solution

3.40 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

This is a physical Entity Relationship Diagram It has been divided into three tables name... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management of Information Security

Authors: Michael E. Whitman, Herbert J. Mattord

4th Edition

1285062297, 1285062299, 978-1285062297

More Books

Students also viewed these General Management questions