Untitiled Diagramhtml-draw.iox← → https://exp.draw.io/ImageExport4/exportexportps M VUDU My Mo es ๏ nbo O um bir T Browse TED Talksa Amazoncom ThankD favo te shit -Nirvana Massage CDImportant Docs. 401kASL . Am encan S.DDD Tha Massage Vide.D Victor 's Secret AnD Other book narksrahoo!tThe Vapor BarPep.Astrolabe Free Char.Astro abe F ee Char.Astrology AnswersHarem PantsGo»exportDepartmentProjectPK ProjectCodeEmployeeProject, EmployeeFK ProjectCodeFK EmployeeNoow 3FK DepartmentNoTextexport pdfExercise2.pdfShow allX9:28 PMType here to search2/27/2019

Question
Asked Feb 28, 2019
66 views

Create the physical level ERD. 

I believe my physical level ERD is missing several parts. However, the assignement didn't give many business constraints, if any. Namely, that (from a table list.)(I have used many of my questions around these exercises, due to a lot of confusion and lack of confidence in my work) a company wants to keep track of employee assignment to company projects.

I, suppose, I just want to make sure that I am creating a physical level ERD.... The picture attatched is my work. What makes me nervous, is that my diagram doesn't look much different then my logical level ERD.

Untitiled Diagramhtml-draw.iox
← → https://exp.draw.io/ImageExport4/export
export
ps M VUDU My Mo es ๏ nbo O um bir T Browse TED Talks
a Amazoncom Thank
D favo te shit -Nirvana Massage C
D
Important Docs. 401k
ASL . Am encan S.
D
D
D Tha Massage Vide.
D Victor 's Secret An
D Other book narks
rahoo!
t
The Vapor Bar
Pep.
Astrolabe Free Char.
Astro abe F ee Char.
Astrology Answers
Harem Pants
Go
»
export
Department
Project
PK ProjectCode
Employee
Project, Employee
FK ProjectCode
FK EmployeeNo
ow 3
FK DepartmentNo
Text
export pdf
Exercise2.pdf
Show allX
9:28 PM
Type here to search
2/27/2019
help_outline

Image Transcriptionclose

Untitiled Diagramhtml-draw.iox ← → https://exp.draw.io/ImageExport4/export export ps M VUDU My Mo es ๏ nbo O um bir T Browse TED Talks a Amazoncom Thank D favo te shit -Nirvana Massage C D Important Docs. 401k ASL . Am encan S. D D D Tha Massage Vide. D Victor 's Secret An D Other book narks rahoo! t The Vapor Bar Pep. Astrolabe Free Char. Astro abe F ee Char. Astrology Answers Harem Pants Go » export Department Project PK ProjectCode Employee Project, Employee FK ProjectCode FK EmployeeNo ow 3 FK DepartmentNo Text export pdf Exercise2.pdf Show allX 9:28 PM Type here to search 2/27/2019

fullscreen
check_circle

Expert Answer

Hey.....

The actual design of database can be represented  by  physical E- R   diagrams.Physical ERD look different in visualisation.

You have to mention all the primary keys and foreign keys in some specific way.

I would like to suggest you to use" visual paradigm" to draw ERD.Here you will find an o...

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: What is a solid state disk?

A: Solid state disk drive or solid state drive (SSD) is a non-volatile that stores (or persists) data i...

question_answer

Q: Select Invoice_number, invoice_due_date, payment_date and the number of days late for those invoices...

A: Note: The given query has been compiled and executed in "sqlfiddle" online compiler. Creating an “In...

question_answer

Q: make the Matlab code for the given question no 5 and 6

A: Note: This program is compilde and executed in MATLAB/OctaveThe program has the following algorithm:...

question_answer

Q: I need help with creating a main.css, I already have the HTML.the details are in the pic and I will ...

A: You can use following code in your main.css file to format your HTML document.Note: Make use of <...

question_answer

Q: I now must create a physical Entity Relationship diagram from this list table. While, I feel more co...

A: The table has 9 columns and they can be grouped roughly under 3 entities as follows:Project – Projec...

question_answer

Q: Write a program that coverts a zip code to a bar code. The bar codes use large and small bars. We wi...

A: Solution:#Define the functiondef checksum(zip):    #Declare the empty variable    sum = 0    #Loop e...

question_answer

Q: SQL(Oracle): How do I create an index for the number of days it takes to ship an order? i.e. shipdat...

A: Since we need to create an index based on a calculated field we need to create a calculated index. T...

question_answer

Q: How do I write a Python program that asks the user to enter an integer with the "input" function, su...

A: We can execute the input line inside a try block which will raise a ValueError in case the input is ...

question_answer

Q: Consider the following procedure: procedure mystery (x, y, z); integer x, y, z;beginz = 2; y= z+x;en...

A: Pass by reference copies the location of argument to the parameter. Hence, the final value of n, A[1...