Instructions: in sql server, create a new database called university. given the erd in this document, write the create table statements to construct the tables for this database. be sure to use reasonable data types and create all tables, attributes, primary keys, foreign keys, and "not null" constraints in your statements where appropriate. to receive full credit for this assignment, your create table statements must be executed in sql server. in the space provided below the erd, type your create table statements. then, in sql server, after you execute each create table statement, issue these two statements: select * from [table name]exec [table name].note: exec [table name] is a built-in stored procedure that you run to easily see your table structure, including fieldnames, data types, primary keys, foreign key constraints, etc. it’s a very useful tool. take a screen shot of your queries and their results and paste the screenshot below each create table statement. put each table on a separate page of this document. to illustrate, the campuses table has been created for you on the page following the erd and narrative description section. example – how your output should look for each tablecampuses: create table campuses(campusid int, campusname varchar(20),constraint pk_campuses primary key (campusid))

Me dangers of social media and the internetexplain what each means: 1) social media and phones have become an addiction.2) outside people have access to you all the time.3) cyberstalking4) cyberbullying5) catphishing6) viruses7) identity theft8) credit card fraud9) hacking10) money schemes

Nikki sent flyers in the mail to all houses within the city limits promoting her computer repair service what type of promotion is this and example of

Develop the program incrementally: a) start by reading and displaying each line of the input file to make sure you are reading the data set correctly. b) use the split string method to extract information from each line into a list. print the list to prove that this step is working correctly. d) convert the exam scores to type int and calculate the student’s average. display those items to prove this step is working correctly. e) create a tuple containing the six items for each student (name, exam scores, exam mean). display the tuples to prove this step is working correctly. (optionally, you may want to have the exam scores in a list so your tuple is (name, scores_list, f) append each tuple to a list. display the list to prove this step is working correctly. g) use the sort list method to re-order the tuples in the list. display the list to prove this step is working correctly. h) use a for statement to display the contents of the list as a table (with appropriate formatting). i) use a for statement to calculate the average of all scores on exam #1, then display the results. note that you could have calculated this average within the first loop, but we are explicitly requiring you to do this calculation by looping though your list of tuples. j) add the logic to calculate the average of all scores on exam #2, then display the results.