Solve all

5. Consider the predicates: C(x): "x is in the class." M(x): "x is a computer science major." Express each of the following statements using these predicates, quantifiers, and logical connectives, where the universe is the set of all college students. (a) There is a computer science major who is not in the class. (b) At least one computer science major is in the class. (c) Every computer science major is in the class.Question 1.1) The main issue in the above mentioned network is 1. The issue in transferring large sized files across the network. 2. Physically it is difficult to add computers to the network, because the ceiling is at too high, so installing cable for the new addition to the network is bit difficult. Question 1.2) is it a peer-peer or client server technology. The technology used here is client server technology, it has a centralized control in the network. Question 1.3) The changes in need in the equipment It is better to use a switch in the network to achieve the centralized control, that using a Ethernet Hub. Because switches will have it own memory with all the hosts in the network, so it will avoid the broadcasting effort before starting the transfer of data. It will communicate precisely with the intend receiver over the network. Question 2) Below are the reasons if a computer in the network is not getting the internet. 1. Basic thing was the cable might not plugged well to the computer. 2. Gateway of the internet was not properly configured. 3. Ethernet drivers are not updated to current version. Question 3.1): Type of cable used. Since the network was defined in star topology it is better to go with "Twisted Palr Fiber" cable. Question 4): Network Address: It is a unique identification for a host that was connected to any kind of network. Host Address: It is the physical address of a computer, popularly called as the mac address. It comes with a range under the network. Subnet Mask: It is a 32 bit identification of a host in the network, used to identify the IP address by doing the AND operation bitwise on the netmask. Name one Network service: Helps to achieve client-server technology across all the computers, provides easy way to communicate host to host.6. (Submit a screenshot of your written or typed answer.) The fitness trainer wants to learn more about exercise habits of MATH 1P98 students. You will report your findings on the mean number of days that all MATH 1P98 students exercise for more than 20 minutes and whether it differs between females and males. Based on the results you have obtained from Questions 4 and 5, prepare a brief (no more than 34 of a single-spaced page, Times New Roman font size 12) report. This report should include three headings and should include any findings you think are noteworthy: Introduction (statement of problem, sample size, survey details, context, etc.), Results (report, summarize, and interpret the results of the confidence interval and hypothesis test), and Conclusions/Recommendations (inference on the population, limitations of study, recommendations to improve future study, etc.).. Filter the data so that you can separate the number of exercise days for female students and the number of exercise days for male students. (There is nothing to submit for this part.) . Use Excel to compute the summary statistics for each sample. Since you will use these values in calculations. write x and s with four decimals. For this part. submit only the completed table. . Identify whether the two samples are independent or dependent. Provide an explanation. . Use the sample data to construct a 95% condence interval by hand to estimate the mean difference of the exercise days between female students and male students. Show your work. including all calculations. . Check your answer for part d. using the Brock Excel calculator. Submit a screenshot of that sheet. including all input values and output results. Report the 95% condence interval with three decimal places. Interpret this condence interval in the context of the problem. . Does the condence interval suggest there is a difference between the number of days that female MATH 1P98 students exercise and the number of days that male MATH 1P93 students exercise? Explain how you know. If there is a difference. identify which group exercises on more days. on average. SQL Questions: Write the following SQL queries: 1. Print the names of professors who work in departments that have fewer than 50 PhD students. 2. Print the name(s) of student(s) with the lowest gpa. 3. For each Computer Sciences class, print the cno, sectno, and the average gpa of the students enrolled in the class. 4. Print the course names, course numbers and section numbers of all classes with less than six students enrolled in them. 5. Print the name(s) and sid(s) of the student(s) enrolled in the most classes. 6. Print the names of departments that have one or more majors who are under 18 years old. 7. Print the names of students who are taking both a Computer Sciences course and a Mathematics course. 8. For each department that has one or more majors with a GPA under 1.0, print the name of the department and the average GPA of its majors