Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

****** Topic is Employee Attendance Database System****** You are a consultant that have been hired by XYZ company to provide a project proposal to design

******Topic is Employee Attendance Database System******

image text in transcribed

image text in transcribed

You are a consultant that have been hired by XYZ company to provide a project proposal to design and implement a database management solution. Currently, XYZ does not have in place a repository database where they can centralize all their information. XYZ would like to have in place a Database system that would allow them to centralize all their data in order to create reports and easy management of records. Each question is worth 25 pts. 1. Write about the benefits of implementing a Database System. No less than 200 and no more than 500 words. 2. Develop a list that includes all the major entities (tables) needed for your propose Database System. You also need to provide a brief discussion for each entity. You need to have at least 7 and no more 12 tables for the project. See example below: This is just an example, depending on the database systems you are designing your entities will be different. 3. Provide information about how these entities relate to each other. Refer to entity relationships (one to one, one to many, many to many). Example: - A customer can have many orders and an order can have only one customer. 4. Create an ERD Diagram

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago