Schema diagram for the database shown aboveQUESTIONSChoose a database application with which you are familiar.Design a schema and show a sample database for that application, using the notation of the figures above.What types of additional information and constraints would you like to represent in the schema?Think of several users of your database, and design a view for each.Write appropriate SQL DDL statements for declaring your database schema.Write appropriate SQL DDL statements for database schema as shown above.Write appropriate SQL DML statements for inserting records into your database schema.Write appropriate SQL DML statements for inserting records into database schema shown above.With the aid of Microsoft SSMS (SQL Server Management Studio), create both database schema and insert 10 records into each relation for each database.Specify primary keysSpecify foreign keysAll sample SQL statements must be submitted. STUDENTNameStudent numberClassMajorGRADE REPORTSmithBrown17CSStudent_numberSection_identifierGrade2CS17112B17119COURSE85Course nameCourse numberCredit hoursDepartmentCsIntro to Computer ScienceCS1310492AData StructuresCS3320CS102BDiscrete MathematicaDatabaseMATH24103MATH8.135CS3380CSSECTIONPREREQUISITESection identifier Course_numberPrerequisite_numberCS3320SemesterYearInstructorCourse_number85MATH2410Fall07KingAndersonCS338092CS1310Fall07CS3320SpringCS3380МАТН241010208KnuthChangAnderson112MATH2410Fall08CS3320CS1310119Cs1310Fall08135CS3380Fall08StoneSTUDENTName Student numberClassMajorCOURSECourse_name Course_number Credit_hours DepartmentPREREQUISITECourse number Prerequisite_numberSECTIONSection_identifier Course_number SemesterYearInstructorGRADE REPORTStudent_number Section_identifier GradeGo

Actually, database is a used to stores the data\information.

Answered: Choose a database application with…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Schema diagram for the database shown above

QUESTIONS

Choose a database application with which you are familiar.

Design a schema and show a sample database for that application, using the notation of the figures above.
What types of additional information and constraints would you like to represent in the schema?
Think of several users of your database, and design a view for each.
Write appropriate SQL DDL statements for declaring your database schema.
Write appropriate SQL DDL statements for database schema as shown above.
Write appropriate SQL DML statements for inserting records into your database schema.
Write appropriate SQL DML statements for inserting records into database schema shown above.
With the aid of Microsoft SSMS (SQL Server Management Studio), create both database schema and insert 10 records into each relation for each database.
1. Specify primary keys
2. Specify foreign keys
3. All sample SQL statements must be submitted.