Using Database Design Language Dbdl See P 193 Text Describe Following Tables Used College Q37081849

Using, database design language (DBDL – see p. 193 in the text),describe the following tables to be used for the college database.Be sure to underline the primary keys, and notatethe foreign keys as shown in the text.

1. For the Department table, store its number and name
2. For the Advisor table, store the advisor number and name (firstand last), and the number of the department to which the advisor isassigned
3. For the Course table, store the course code and description(MTH 110, Algebra)
4. For the Student table, store the student number, name (last andfirst), and the number of the advisor assigned to that student
5. For the StudentCourse
   OR

    

   

   OR