Elementary School Student Laptop Tracking DatabaseA database inventory system is needed to record the assignment of school$-$owned laptops to students. The current arrangement allows all third and fourth grade students to obtain a school supplied laptop. The teachers of each class have the academic freedom to develop some of their curriculum and choose the needed software to be installed on the laptops. A student is assigned to a classroom and teacher, and currently there are three third grade classes and three fourth grade classes. Classes are designated with Grade $(3$ or $4),$ Academic Year, and Section $($A$,$ B$,$ or C$).$ The data to record for the laptops includes serial number, make, model, amount of memory, and hard drive size. A student is only to have one laptop at any time. The system does not need to track a history of who has borrowed a laptop but does need to show who currently has a given laptop, when it was checked out, and when returned. Students are expected to checkout their laptop at the beginning of the school year and return it at the end. In cases that a laptop becomes defective, the student is issued a different laptop and the laptop is recorded as not working.The system is also to track the software for which the school has licenses and approved to be used by the students, including the name, version, recommended memory and hard drive requirements. Because different grades and classes have different requirements, the system needs to track which software is needed for each classroom. The system is to track the software installed on each laptop, the date it was installed, and should not allow an assignment of software to a laptop where the recommended memory exceeds the laptops memory.Create a database to fulfill the requirements described. Your solution should include the following:

$1.$ Entity$-$Relationship Diagram showing all needed entities and attributes, relationships, cardinality and participation, primary keys, and foreign keys.

$2.$ A data dictionary including field names, the table where they exist, data types, and descriptions

$\mathrm{.}3.$ All needed database objects on the SQL server including tables, views, a stored procedure, and a trigger. Special attention should be given to ensuring data integrity constraints are applied

$\mathrm{.}4.$ All SQL scripts to create all the above database objects.