The physical diagram must:

Include a text label that states your name and student number displayed on the diagram.

Diagram all entities $($Tables$).$

Identify all attributes for all tables.

Identify the primary keys $($if appropriate$).$

Use appropriate datatypes for each of the attributes. $($VARCHAR$(50)$ for everything is not appropriate$).$

Have appropriate foreign keys with the correct cardinality between tables.

Consistent, basic naming conventions $($see next section$)$

Basic naming conventions

Do not use spaces in any names, whether table or columns. Use underscores.

Everything is lowercase.

Primary keys should use the name of the table, followed by an underscore and the letters $"$id$"$

E$.$g$.$: the customer table has the primary key customer$\_$id

E$.$g$.$: the product table has the primary key product$\_$id

etc.

Table names can be either singular or plural. Whichever you choose, the same naming convention must be used throughout.