Talent Agency

Diagrams.png

Clifford Heath — Thu, 20 May 2010 04:51:48 GMT

This is an extension to the ActiveFacts Metamodel (upcoming version) to show how ORM2 diagrams are modelled

Talent Agency CQL

Clifford Heath — Thu, 29 Oct 2009 02:23:16 GMT

I converted the Talent Agency file to Constellation Query Language using my ActiveFacts converter, which worked correctly (and generated an SQL database design almost the same as NORMA's, with just these tiny changes:

Dropping the space from "Stage Name" (the version of CQL that supports multi-word names isn't yet finalised)
Adding an initial upper-case to the "agency" role name to avoid ambiguity within the reading
Dropping the trailing hyphen-binding -photo from BinaryFile (trailing adjectives are broken in the released version of CQL)

Then, to improve the appearance of the CQL (without changing its functionality) I:

Added a number of reverse readings for fact types that have embedded uniqueness or mandatory constraints; such constraints can only be absorbed onto the last role player of a reading so were appearing as external constraints in CQL.
Changed the reference mode "id" to "Id", "code" to "Code" and dropped the underscore (this is not removed automatically by my NORMA converter at present.

The result is this attached CQL, directly from the converter (no edits). It still generates the same SQL database, which has a list of tables differing only from NORMAs in that the Login table is absorbed by ActiveFacts, independent in NORMA (due to the deontic constraint which is disregarded by the current version of ActiveFacts.

I hope you'll be surprised how tractable the resultant CQL is.

Talent Agency NORMA file

Tyler Young — Tue, 27 Oct 2009 19:30:34 GMT

See the Talent Agency description document for details about the domain and how this model came about.

This model is released under the GPLv3 Open Source License.

Talent Agency Details Document

Tyler Young — Tue, 27 Oct 2009 19:28:06 GMT

A model of a talent agency and the audition process. I worked as a secretary for a local talent agency in 2002, then started doing their website as I taught myself PHP and MySQL. After redoing the website once, I turned it over to another developer. Afterward, I decided to start modeling my "ideal" scenario that would optimize the work flow for people applying to the agency and for casting directors looking to hire talent.

During the time that I was modeling this, I noticed how quickly I tended to "rat hole" down other domains that weren't necessarily specific to the domain. You'll see parts of the model dedicated to scheduling, invoicing, and addresses. Those areas are painfully thin, and I was just trying to get by with as little as possible so that I could focus on the more domain-specific areas of the model.

Download the NORMA model if you want to take it for a test drive!

This model is a result of that effort. It is not currently in production, and was not designed while working for the talent agency. In other words, nobody owns this model except me. I hereby release it under the GPLv3 license.