Answer the following: when creating database, after identifying tables, add necessary fields using these 6 guidelines (fill blanks): 1. Include the _____ data 2. Design for ____ and for the ____ 3. Store data in their ______ parts 4. Add ______ _______ to a table 5. Design to accommodate ______ arithmetic 6. Link tables using _____ fields

please help with question 2 this is for Database Systems

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…

Discuss the benefits and drawbacks of using stored procedures in database development.