Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start date IV EMPLOYEE Fname Minit Lname San Bdate Address Sex Salary Dno M WORKS ON Essn Pho Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints

When constructing a database, the designer must know what types of relationships exist between records in different data sets, such as one- to-many or many-to-many. Give three examples for each of these relationships.

Question  A city college would like to maintain their academic information in a MySql database system.  The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…

Describe the benefits of using a data dictionary in the database design phase.