Convert a ER model into a relational database schema expressed in SQL DDL, with appropriate constraints.

Use Create Table Command

Collections

The following diagram shows entities, attributes and relationships for the photo collections that are managed in the pics.net

Comments on Collections:

a collection is simply a group of photos, identified by a numeric ID

each collection must have a title (up to 50 chars) and may have an arbitrary text description

each collection has a key photo which is used to represent the whole collection in the interface

photos are marked with the rank order (a small positive integer) in which they appear when the entire collection is displayed; this allows users to choose how the collection is viewed

some collections are built by an individual user and owned by that user, who is the only person who can modify which photos are in the collection and the order that they appear

other collections are associated with a group, and any member of the group can modify which photos are in the collection and the order that they appear