ORDER$($customer#$,$ order#$,$ order$-$date, part#$,$ quantity$)$

A relational table ORDER contains information about the parts ordered by the customers $($customer#$).$ An order is uniquely identified by an order number $($order#$).$ A part is identified by a part number $($part#$).$ An order consists of one or more parts. An order is submitted by a customer on a given day $($order$-$date$).$ A quantity of each part is determined an attribute quantity.

STUDENT$($student$-$number, full$-$name, degree, total$-$credits$-$ required$)$

A relational table STUDENT contains information about the students. A student is described by a student number $($student$-$number$)$ and full name $($full$-$name$).$ Each students is enrolled in one degree $($attribute degree$).$ An attribute total$-$credits$-$ required contains information about the total number of credits that must be collected by a student to get a degree.