Question: ****** 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******

******Topic is Employee Attendance Database System****** You are a consultant that have

been hired by XYZ company to provide a project proposal to design

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!