Loading...
Posts on the
Design Decomposition Blog
Iridium Satellite Collision in Space
You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
(The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
Atomicity
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
Well-Formed Business Process Diagrams
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram. To start, here are three criteria from [...]
November 18, 2008
Recent Business Process Modeling Books
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good. The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There are [...]
October 9, 2008
The Design Decomposition Blog
is written by Doug Barry.
Loading...

The following figure shows the relational schema for this example. Employee in this example includes teachers and support personnel. Teachers include instructors, professors, and graduate students in a workstudy program. In this example, one set of type codes is used for all these types of employees.

There are two intersection entities in this schema: Student/Course and Employee/Course. These handle the two many-to-many relationships: 1) between Student and Course, and 2) between Employee and Course. In the first case, a Student may take many Courses and a Course may be taken by many Students. Similarly, in the second case, an Employee (one of the types of Teachers) may teach many Courses and a Course may be taught by many Teachers. Also see more on many-to-many relationships (new window).

Relational schema for example

Next: Employee Table. Also see the related content below.

Related content for: Relational schema for example

More on the general topic: Type codes

Read more free articles on this site

There are nearly 400 pages of articles on this site with over 50 pages on object-relational mapping.

Search this site for more articles

Custom Search

Browse this site for more articles

Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current article: Relational schema for example.

Loading...

Related recent articles from Google News

MODX Revolution 2.0 has been released
CMS Critic
It is built on a modern, object-oriented core with a fully documented API for developers, sits on top of a robust database Object-Relational Mapping (ORM) ...
and more »
26 Jul 2010 at 7:54am
Mapping Quest Drives .NET ORMs
Redmond Developer News (blog)
This week, Microsoft shed some light on vNext of its "official" object-relational mapping tool, ADO.NET Entity Framework. On Wednesday, the first preview of ...

15 Jul 2010 at 8:22pm
EMC Big Data Play Continues: Greenplum Acquisition
Enterprise Irregulars (blog)
We have been forcing round holes into square pegs with object/relational mapping for years, but the approach is breaking down. Tools and datastores are ...
and more »
7 Jul 2010 at 11:08pm
Faster Apache Cayenne 3 for Java Framework
InternetNews.com
Cayenne provides object relational mapping (ORM) as well as caching and persistence features for Java applications. With the new release, the Apache project ...
Apache Releases Details Of Cayenne Java Framework eWEEK Europe UK
all 3 news articles »
7 Jul 2010 at 7:07pm
Google Chrome Vs Mozilla Firefox
Boosh News (press release) (blog)
One impressive features of CakePHP is its Object Relational Mapping (ORM) framework, which allows you to streamline SQL queries by presenting tables as ...
and more »
19 Jul 2010 at 10:32pm
More related news on: "object-relational mapping"

Related books at Amazon.com

Pro LINQ Object Relational Mapping in C# 2008
Pro LINQ Object Relational Mapping in C# 2008
by Vijay P. Mehta
Average Customer Review: 4 stars based on 11 reviews.
Customer Review: I am not sure what the 2 and 3 star reviews are about, because I thought this book was excellent, and considering the book says "intermediate" I'm not sure why people were expecting a "deep technical ORM, LINQ to SQL, or EF" book. The book is broken into 5 different parts: Part 1 - ORM Concepts - This is really good background for p...
Foundation for Object / Relational Databases: The Third Manifesto
Foundation for Object / Relational Databases: The Third Manifesto
by C. J. Date, Hugh Darwen
Average Customer Review: 3 stars based on 4 reviews.
Customer Review: Mr. Data and Mr. Darwen have much to say in this book. The question is will community of "database" people read it, assimilate it, and get to sufficient mass to discuss the merits of the concepts described in this book? And, if that does happen, will it be too late to implement any of the concepts in a real DBMS? There is no question...
Object Data Management: Object-Oriented and Extended Relational Database Systems
Object Data Management: Object-Oriented and Extended Relational Database Systems
by R.G.G. Cattell
Publisher: Addison-Wesley
Publication Date: June 1991
More related books: Search Amazon.com for object-relational mapping