Use ms sql to create database QNMSYSConnect sage 300 to database QNMSYSCreate new company "DATABASE "QNMDAT" Set servername QNM555Address 765 JohnstreetCity torontoStation toontarioPostcode M12 345Name QWE RTYPhone 123456789 Screenshot sesktop ribbonScreenshot Final result  please show me the screenshot .

SQL script which is the physical design for this database   ### Animals This table contains the following data about all animals in the zoo. - animal ID (primary key) - animal name - animal birthdate - species - habitat (foreign key) [1 habitat to many relationship]   ### Habitats This table contains data about the habitats in the zoo.  Each animal lives in a specific habitat.  The habitat table should include the following data - habitat name, foreign key) - habitat location   ### Database CREATE DATABASE zoo;     Write queries to create the tables. Be sure to include primary keys for each table and the required foreign keys and referential integrity actions.   Add appropriate indexes. This database requires at least 2 indexes in addition to those automatically created by MySQL.

SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information: Car ID Month Day Count You need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team. Query the frequency of each car's use by month and day

Write SQL command to create above table “course” and insert the above values.   ccode cname C101 Database concepts and design C102 Software Engineering C103 Human Computer Interaction C104 Programming-2 C105 Multimedia Write SQL command to create above table “student” with REFERENCES and insert the above values. Hints:- In table student ccode is a FOREIGN KEY.     sid sname ccode 101 Abdullah Ahmad C101 102 Ali C102 103 Hazmi C104 104 Khalid C102 105 Ali Ahmad C103   Write SQL command to display sname(student name) from student table and corresponding cname(course name) from course table using inner join.   Your output should be like this sname cname Abdullah Ahmad Database concepts and design Ali Software Engineering Hazmi Programming-2 Khalid Software Engineering Ali Ahmad Human Computer Interaction    (in a program mycmpiler)