SPN 100 - Final Exam Study Guide

Questions is attached - Only E, F and G

Book (ISBN, Category, BTitle, Quantity,CID) Sales (SalesNo, Month_Year, TotalSales, ISBN) Shop (RegNo, Location, SalesNo) Customer (CID, CName, TelNo, Age)   (ii)What was the title and category of the book that the customer Emekabought? (iii)Who purchased the book in the Coding category,or the quantity is greater than two? (iv)What isthe total sales and location of the shop with the registration number "REG KL 100" in the month ofApril 2021? (v)Display the identification number, name, age together with the total salesof the customers who purchasedthe Computer Fundamentals title book.

question is attached as picture

C Language - Given a highway number, indicate whether it is a primary or auxiliary highway. If auxiliary, indicate what primary highway it serves. Also indicate if the (primary) highway runs north/south or east/west.

An ISBN (International Standard Book Number) is a 10 digit number that is used to identify a book. The first nine digits of the ISBN number are used to represent the Title, Publisher and Group of the book and the last digit is used for checking whether ISBN is correct or not. To uniquely identify a book a 10-digit ISBN number is used. The rightmost digit is checksum digit. This digit is determined from the other 9 digits using condition that 10d, + 9dz + 8dg + + d4o must be a multiple of 11 (where d, denotes the i" digit from the right). The checksum digit d; can be any value from 0 to 10: the ISBN convention is to use the value X to denote 10. Write a C program using pointers that receives a 10- digit ISBN, and computes the checksum, and reports whether the ISBN number is correct or not. Example: 007462542X = 10°0 + 9*0 + 8*7 + 74 + 6*6 + 5*2 + 4*5 + 3"4 + 2*2 + 110 = 176 Since 176 leaves no remainder when divided by 11, hence it is a valid ISBN. Note: When the check digit turns out…

Customer (CID, CName, Street, City, State, Gender)Agent (AgentID, GName, Position, Salary, Gender, BranchNo)Invoice(InvoiceNo, CID, AgentID, Product, Quantity, Total_amt) List the name of agents, position and salary for all agents that begin with ‘Sales’ in their title position and with salary more than the average salary. Example of titles with ‘Sales’ are ‘Sales Executive’, ‘Sales Manager’, ‘Salesman’ and many other titles. Sort the list by name in alphabetical order

The steps required to construct an ADT. Please complete the following sentences with your answer.

Java Programming Project You need to make an exam application in the project. Write the project using JavaFX. Do not use a database. Accordingly, what is requested must be performed: 1. Adding questions to the question bank: different types of questions should be added to the question bank. Question types include multiple choice, True/False, fill-in, and classic type questions. It is mandatory to use inheritance and polymorphism in writing classes related to questions and in using their objects. For example, a multiple choice question should have the following information: a) question text b) answer options such as a, b, c, d c) answer d) points e) degree of difficulty (such as easy, normal and difficult) In the upper classes, taking into account the content of other types of questions and subclasses must be determined which properties should be. 2. Removing a question from a question bank: finding a question that will be deleted first when removing a question from a question bank it…

Business Rule - "no pilot can fly more than 10 hours within any 24-hour period"   Draw a ERD diagram of the following Business Rule above.

uèstion 22 Satisfiability of a Boolean expression means there is a combination of values that make it (true, false) A Moving to another question will save this response

C LANGUAGE ONLY. ANSWER ASAP. Using the program provided below: Add the following features that are listed below to the provided program: Store student ID numbers and their corresponding GPAs in a structure. ID numbers should be 8 digits. (Ex. 11926743) and GPA should be (0.0, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0) Add students Remove students Display the list of students Start of code: FILE NAME: linked_lists.h #ifndef LINKED_LISTS_H#define LINKED_LISTS_H struct node {    int data;    struct node* next;}; void insertAtBeginning(struct node** head, int data);void insertAtEnd(struct node** head, int data);void insertAfter(struct node* prev_node, int data);void deleteNode(struct node** head, int key);void swapNodes(struct node** head, int x, int y);void printList(struct node* head); #endif FILE NAME: linked_lists.c #include <stdio.h>#include <stdlib.h>#include "linked_lists.h" void insertAtBeginning(struct node** head, int data) {    struct node* new_node = (struct…

Computer Science Using R language Student: 70, 80, 90, 85, 95, Create a histogram and Q-Q plot of variable " Student".

Question is attached.

Determine the number of anagrams of the word INEQUALITIES. Enter your answer in the box below. Answer =

Answer asap. Wrong answer would downvoted.

Sentential Logic Translation (It is mandatory to use the Letters given in the following questions; do NOT choose other Letters): Not both the Brothers Four and Drifters will perform, unless neither Elvis Presley nor Patsy Cline will sing. (S1: Elvis Presley will sing; S2: Patsy Cline will sing; P1: the Brothers Four will perform; P2: Drifters will perform) The concert is in San Francisco (S) only if the concert is not in California (C), provided the weather is good (G). If neither inflation (I) nor unemployment (U) continues at their current low rates, then there will be recession (R) if and only if stock prices (S) do not drop dramatically and either heating oil (H) or gasoline prices (G) continues to rise. Any ONE (i.e., only ONE) of my three children [Peter, John, Mary] is telling the truth. (P, J, M)

Single Lane Highway Problem Description Certain number of cars are passing a single lane road. Speeds of all cars vary. It is easy to see, that depending on the speeds of the cars various groups will be formed. Being a single lane road passing/overtaking is not allowed. Given speeds of cars, calculate how many groups can be formed if all possible permutations are taken into account. Refer example1 for better understanding. Print number of groups divided by the number of permutations. Constraints 0 <= N < 10 ^ 5 0 <= speed of individual vehicle < 10 ^ 9 Input First line contains an integer N, which denotes the number of vehicles Second line contains N space separated integers which denotes the speed of individual vehicle. Output Print number of groups divided by the number of permutations rounded upto 6 decimal places. Time Limit 1 Examples Example 1 Input 3 10 20 30 Output 1.833333 Explanation: So all possible permutations are: {10 20 30} {10 30 20} {20} {10 30} {20 30}…

3. MOH codes are a 5-digit combination of alpha and digit numeric and an alpha suffix Create a table showing the Suffix (Alpha) that are going to be included in coding of diagmostic test Be sure to include two columns in your table: Alpha suffix and code definition

Activity 7 Guessing Game There is list of word, the interpreter will choose a word randomly. The user has to input his names and then, he will be asked to guess the word by accepting any alphabet. If the random word contains accepted character, it will be shown as the output (with correct placement) else the program will ask you to guess another alphabet. User will be 50% of the total number of characters to guess the complete word. Requirements 1. There must be 10 words of different length. 2. The words must be in random. 3. It should accept lower case and upper case letter 4. The number of turns left must be display 5. All wrong characters are also display

* Question Completion Status: A Moving to another question will save this response. Question 9 Given the function F(X,Y,Z) =XZ + Z(X'+ XY), the equivalent, most simplified Boolean representation for F is O a. Z+XYZ O b.XZ O c. Z O d.Z+YZ A Moving to another question will save this response. مشمس 36°C

Use ML code to plot. Warning: not to do incorrect or provide code should attach the code with plotting.

1.Correct answer will be upvoted else thumbs down.

*Computer Fundamentals and Programming using Compound assignment

"The Parchment Book Publishers" Case Study a number of packing staff who each take an order from the computer system, and retrieve the items necessary to fill the order from the warehouse shelves. The computer system will automatically send requests to the printing department for more stock if the stock levels in the warehouse drop below a "The Parchment" book publishers is a small publishing company that publishes books from lesser specific threshold. known authors and also markets the books to customers via an online store. When an author is As each order is filled by the specific warehouse staff member, it is then flagged for shipment to the contracted to write a book, they receive a $2000 advance against all future sales. Authors receive a customer on the computer system, and specific shipping and handling staff will collect the packaged flat 5% of sales, and once the advance is paid off, begin to receive royalties on sales every quarter. order and schedule it for delivery at the…

fill in the crossword