Improve company productivity with a Business Account.Sign Up

x
?
Solved

Database Diagrams

Posted on 2011-03-13
2
Medium Priority
?
1,259 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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A method of moving multiple mailboxes (in bulk) to another database in an Exchange 2010/2013/2016 environment...
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
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. …
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

595 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