User Account

All Pages

Create an erd diagram and a logical diagram

Assignment Help Computer Engineering
Reference no: EM131721720

Before completing your assignment, watch the following videos:

Sampson, Aaron. (© 2015). Generic design and modeling databases: database design methodology.
Sampson, Aaron. (© 2015). Generic design and modeling databases: overview of the logical database design.
Sampson, Aaron. (© 2015). Generic design and modeling databases: creating an erd for designing a database.

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 screen shots).

Your report should be one unified document. Do not submit multiple parts to the assignment.

Reference no: EM131721720

Questions Cloud

How much will the bank pay in interest cost : Happy Valley Bank borrows $125 million overnight through a repurchase agreement (R2) collateralized by Treasury bills.
Describe what contribution margin means : Continuing the scenario from the Module 3 discussion: Describe what contribution margin means and how you would calculate it for your division.
What are major characteristics of common and preferred stock : What are some of the major characteristics of common and preferred stock? Find a preferred stock that has been issued and share it with the class
What is the projected available funds gap : Lavendar Bank of New York expects new deposit inflows next month of $330 million and deposit withdrawals of $425 million.
Create an erd diagram and a logical diagram : Create an ERD diagram and a Logical diagram for a company database
Discuss the merit of the given statement : In 150-200 words, discuss the merit of the above statement focusing on both the purpose and limitations of a statement of cash flows.
How much dividend income do the shareholders report : If pheasant pays a $600,000distribution to its shareholders on July 1st, how much dividend income do the shareholders report
What is an equipment design capacity : The vice president of production would like your plant to earn $10,000 per month profit on a 5 day per week, 3 shift per day operation.
What was the annual percentage yield earned : Chris Orange maintains a savings deposit with Santa Paribe Credit Union. This past year Chris received $13.64 in interest earnings from his savings account.

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd