Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Database Diagrams

Posted on 2011-03-13
2
Medium Priority
?
1,253 Views
Last Modified: 2012-05-11
My goal in this problem is to understand it, not to get an answer to this homework question.

8.22. Show how the UNIVERSITY EER schema in Figure 8.9 may be represented in UML notation.
Fig8.9.png
0
Comment
Question by:JCW2
2 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 2000 total points
ID: 35124881
I can't describe the whole thing, since there are parts I'm not sure about, but from I can tell...


The rectangles are your tables. Each ellipsoid is an attribute (column) of its respective table. Your diamonds are the relationships between the tables, and each of these relationships is denoted as a 1-to-many or many-to-many relationship. If I'm not mistaken, the "U" symbols denote one table is a subset of another, where the superset is the one being "stuck by the fork."

Outside of that, what are you having trouble with?
0
 

Author Closing Comment

by:JCW2
ID: 35142646
Thank you for your help.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this article, we’ll look at how to deploy ProxySQL.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

879 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question