World of Art Database – First Iteration

This is the first iteration of the World of Art Database. At this time, there are only two very simple tables in the database. The artist table and the works of art table. They both have a column called ID which acts as the primary key of the table. I prefer to use integers as the unique key of a table. Indexing on integers is very fast and efficient. Using integers also isolates the primary keys from being affected by changes in the domain objects, which these table are used to populate with specific data.

World of Art Database - First Iteration

World of Art Database - First Iteration - SQL Server 2008

In the art world domain, one artist can create one or more works of art. The database diagram illustrates this one to many relationship between the artist and their works of art. The primary key of the Artist table is ID. The foreign key relationship is maintained by the Artist ID column in the works of art table. The artist ID is allowed to exist in only one row of the artist table, but at the same time, the artist ID can exist in one to many rows of the works of art table.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">