SPN 100 - Final Exam Study Guide

Introduction Some number of teams are participating in a race. You are not told how many teams are participating but you do know that:  Each team has a name, which is one of the uppercase letters A-Z.  No two teams have the same name, so there are a maximum number of 26 teams.  Each team has the same number of members.  No two runners cross the finish line at the same time – i.e. there are no ties. At the end of the race we can write the results as a string of characters indicating the order in which runners crossed the finish line. For example: ZZAZAA We can see there were two teams: A and Z. Team A’s runners finished in 3rd, 5th and 6th place. Team Z’s runners finished in 1st, 2nd and 4th place. Scoring the race Each runner is assigned a score equal to their finishing place. In the example above team Z’s runners achieved scores of 1, 2 and 4. Team A’s runners scores were 3, 5, and 6 respectively. The team’s score is the sum of the members score divided by the number of people on…

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.

Explain every step please

Hospital :ER Case Study A General Hospital consists of a number of specialized wards (such as Radiology, Oncology, etc).Information about ward includes unique name, total numbers of current patients. Each ward hosts a number of patients, who were admitted by a consultant (doctors) employed by the Hospital. On admission, the date and time are kept. The personal details of every patient includes name, Medical Recode Number (MRN), set of phone and one address (city, street, code). A separate register is to be held to store the information of the tests undertaken. Each test has unique episode No., category and the final result of test. Number of tests may be conducted for each patient. Doctors are specialists in a specific ward and may be leading consultants for a number of patients. Each patient is assigned to one leading consultant but may be examined by other doctors, if required.

Hospital :ER Case Study A General Hospital consists of a number of specialized wards (such as Radiology, Oncology, etc) .Information about ward includes unique name, total numbers of current patients. Each ward hosts a number of patients, who were admitted by a consultant (doctors) employed by the Hospital. On admission, the date and time are kept. The personal details of every patient includes name, Medical Recode Number (MRN), set of phone and one address (city, street, code). A separate register is to be held to store the information of the tests undertaken. Each test has unique episode No. , category and the final result of test. Number of tests may be conducted for each patient. Doctors are specialists in a specific ward and may be leading consultants for a number of patients. Each patient is assigned to one leading consultant but may be examined by other doctors, if required. u

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

Groups problem help required

ASSIGNMENT BRIEF Introduction Roulette is a popular casino game named after the French word for 'little wheel'. In the game, players may choose to place bets on single numbers or various groupings which will determine their payout. To determine the winning number a ball is spun in the opposite direction of a spinning wheel. As the ball loses momentum it comes to rest in one of the slots of the wheel. Winnings are then paid to anyone who places a successful bet. n 00 2. 1ST12 2ND12 3RD12 1T018 EVEN ODD |19то36 Figure 1: Layout of a European roulette table Numbers can be classified in several ways: 1. Red or Black 2. Odd or Even 3. High or Low - if a number is in the first half of the table it is considered low (1-18). If a number is in the second half of the table, it is considered high (19-36). 4. Dozens - a number can be in the first dozen(1-12), second dozen (13-24) or third dozen (25-36) 5. Columns - A number may be in any of the three columns of the table 6. Zero - the number '0'…

Programming Assignment III In this assignment you are required to be researching some sorting algorithms available and providing some basic description on each algorithm you find. Your grade will be relative based on the number of algorithms you can come up with and their respective specifications. I would be happy with 10 sorting algorithms with clear description and analysis. The following is the specification you need to provide on each algorithm: 1. The name of the algorithm 2. A small paragraph describing the operation of the algorithm 3. The code of the sorting function in the language you prefer (Java, C++, C, Python, C#,). 4. A testing code to run the sorting function using random arrays of sizes: 1000, 10000, 100000, and 1000000 elements. The code should calculate the execution runtime in nanoseconds for each array size sorted. 5. The theoretical O-Notation runtime of the algorithm After providing the above description on the algorithms you find, you are requested to summarize…

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.

None

Python elif if

Question 1: break phrase  Problem statement Breaking a string into two parts based on a delimiter has applications. For example, given an email address, breaking it based on the delimiter "@" gives you the two parts, the mail server's domain name and email username. Another example would be separating a phone number into the area code and the rest.  Given a phrase of string and a delimiter string (shorter than the phrase but may be longer than length 1), write a C++ function named break_string to break the phrase into two parts and return the parts as a C++ std::pair object (left part goes to the "first" and right part goes to the "second").

Question 1: break phrase Problem statement Breaking a string into two parts based on a delimiter has applications. For example, given an email address, breaking it based on the delimiter "@" gives you the two parts, the mail server's domain name and email username. Another example would be separating a phone number into the area code and the rest. Given a phrase of string and a delimiter string (shorter than the phrase but may be longer than length 1), write a C++ function named break_string to break the phrase into two parts and return the parts as a C++ std::pair object (left part goes to the "first" and right part goes to the "second"). Do the following Write your algorithm as code comments. I recommend to follow UMPIRE technique Implement your function

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)

EXERCISE 1 Stock Transaction ProgramLast month Joe purchased some stock in Acme Software, Inc. Here are the details of the purchase:• The number of shares that Joe purchased was 1,000.• When Joe purchased the stock, he paid $32.87 per share.• Joe paid his stockbroker a commission that amounted to 2 percent of the amount he paid for the stock.Two weeks later Joe sold the stock. Here are the details of the sale:• The number of shares that Joe sold was 1,000.• He sold the stock for $33.92 per share.• He paid his stockbroker another commission that amounted to 2 percent of the amount he received for the stock. By writing a pseudo code and flow charts, design a program that displays the following information:● Did Joe make money or lose money? Display the amount of profit or loss after Joe sold the stock and paid his broker (both times).

EXERCISE 1 Stock Transaction ProgramLast month Joe purchased some stock in Acme Software, Inc. Here are the details of the purchase:• The number of shares that Joe purchased was 1,000.• When Joe purchased the stock, he paid $32.87 per share.• Joe paid his stockbroker a commission that amounted to 2 percent of the amount he paid for the stock.Two weeks later Joe sold the stock. Here are the details of the sale:• The number of shares that Joe sold was 1,000.• He sold the stock for $33.92 per share.• He paid his stockbroker another commission that amounted to 2 percent of the amount he received for the stock. By writing a pseudo code and flow charts, design a program that displays the following information:● The amount of money Joe paid for the stock.● The amount of commission Joe paid his broker when he bought the stock.● The amount that Joe sold the stock for.● The amount of commission Joe paid his broker when he sold the stock.● Did Joe make money or lose money? Display the…

EXERCISE 1 Stock Transaction ProgramLast month Joe purchased some stock in Acme Software, Inc. Here are the details of the purchase:• The number of shares that Joe purchased was 1,000.• When Joe purchased the stock, he paid $32.87 per share.• Joe paid his stockbroker a commission that amounted to 2 percent of the amount he paid for the stock.Two weeks later Joe sold the stock. Here are the details of the sale:• The number of shares that Joe sold was 1,000.• He sold the stock for $33.92 per share.• He paid his stockbroker another commission that amounted to 2 percent of the amount he received for the stock. By writing a pseudo code and flow charts, design a program that displays the following information:● The amount of commission Joe paid his broker when he bought the stock.

Modulo Rules Use powers to solve this. Add comments on each line to help me understand. The solution is provided. Write the steps neatly please

Vocabulary Task (C language) Solution given below. How to fix the error in the picture attached. txt file is not being created from this code please also include how to create a txt file and where will it be saved in the computer Natural language processing (NLP) is a field of artificial intelligence that seeks to develop the ability of a computer program to understand human language. Usually, the first step of an NLP system is to convert words into numeric codes. Thus, the system converts an input text into a sequence of numeric codes before any high-level analysis. This process is known as text preprocessing. We can only perform text preprocessing if we have a vocabulary of words and their associated numeric codes. Your task is to create a vocabulary of unique words for a given text file and assign a different number from 1 to N to each unique word, with N being the total number of unique words. You must perform this assignment so that the first word in alphabetical order gets the…

Q2/ A teacher decided to sign students' papers with letters according to their degrees out of 100 if the degree >90 he gives “A", and if the degree >80 he gives “B", and if the degree <80 he gives pass . design decision table for the above system.

discrete structure  could you help me with these two questions

eflection journal on :keyboard and keypads (500 words) - Briefly describe the selected topic in your own words. (DESCRIPTION) - Write few words how it is contributing toHuman computer interaction. (FEELINGS) - Quick example (EVALUATION) - Brief Summary of all above (CONCLUSION).