Create an ERD diagram and a Logical diagram for a company database

computer science

Description

Assignment

Before completing your assignment, watch the following videos:

[video 7 min] Sampson, Aaron. (© 2015). Generic design and modeling databases: database design

methodology. Available from http://common.books24x7.com.lib.kaplan.edu/toc.aspx?bookid=94530

[video 4 min] Sampson, Aaron. (© 2015). Generic design and modeling databases: an overview of the

logical database design. Available from

[video 10 min] Sampson, Aaron. (© 2015). Generic design and modeling databases: creating an erd

for designing a database. Available from

Instructions

You have been hired as an IT consultant for a small (approximately 30 employees) accounting firm.

The company already has a server and is using Windows Server 2016. Continuing with an

appropriate report format that includes a cover page and references, please add to your report the

following:

Create an ERD diagram and a Logical diagram for a company database. You must include the

following tables:

  •  Employee
  •  Position
  •  Salary
  • Client
  •  Include one additional table that you define.

Identify 3–5 attributes for each table. Remember to identify the Primary Key (and foreign keys if

necessary) and show appropriate relationships and cardinality (one to one, one to many).

NOTE: You MUST use Visio to create your diagram. The diagram can be copied and pasted from

Visio into Word (do not export or use screenshots).

Submit your completed report (include all of your sections from units 2, 3, and 4) to the Assignment

Dropbox.

Instruction Files

Related Questions in computer science category


Disclaimer
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.