(c) Assuming Pascal programming language, evaluate the expression; Y sqr(a) + b c mod 4 / d given that a=4, b=6, c=10 and d-3.​

The SQL queries for each question is given below:

i) Select city from manufacturer m, product p where m.ManufactureID=p.ManufacturerID and p.category=‘Boots’;

ii) Select FirstName, Last Name from Customer inner join Sale on Customer.CustomerID = Sale.CustomerID inner join Sale Item on Sale.SaleID = SaleItem.SaleID inner join Product on SaleItem.ProductID = Product.ProductID inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where category = 'Casual shoes' and Manufacturer Name = 'TIMBERLAND';

iii) Select ProductName, ListPrice from Product inner join Sale Item on Product.ProductID = SaleItem.ProductID inner join Sale on SaleItem.SaleID = Sale.SaleID where Sale Date = '14-FEB-2014';

iv) Select Product Name from Product inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where State = 'Washington';

v) Select ProductName from Product inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where ListPrice < 50 and City = 'Phoenix';

vi) Select FirstName, Last Name from Customer inner join Sale on Customer.CustomerID = Sale.CustomerID inner join Sale Item on Sale.SaleID = SaleItem.SaleID inner join Product on SaleItem.ProductID = Product.ProductID inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where ListPrice > 60 and State = 'New Jersey';

vii) Select FirstName, Last Name from Customer inner join Sale on Customer.CustomerID = Sale.CustomerID inner join SaleItem on Sale.SaleID = SaleItem.SaleID inner join Product on SaleItem.ProductID = Product.ProductID inner join Manufacturer on Product.ManufacturerID = Manufacturer.ManufacturerID where ListPrice > 100 or Category = 'flats' and State = 'Illinois';

viii) Select FirstName, Last Name, Wage*MaxHours as Weekly Pay from Employee inner join Wage Employee on Employee.EmployeeID = WageEmployee.EmployeeID order by Wage*MaxHours;

ix) Select E1.FirstName ,E1.LastName ,E1.Hiredate ,E2.FirstName as Mgr_FirstName,E2.LastName as Mgr_LastName , E2.Hiredate as Mgr_Hiredate from Employee E1 inner join Employee E2 on E1.ManagerID = E2.EmployeeID;

x) Select Wage,E1.FirstName ,E1.LastName ,E1.Hiredate ,E2.FirstName as MgrFirstN,E2.LastName as MgrLastN from Employee E1 inner join Employee E2 on E1.ManagerID = E2.EmployeeID inner join Wage Employee on E1.EmployeeID = WageEmployee.EmployeeID;

Read more about databases here:

https://brainly.com/question/518894

#SPJ1

Answer:

Here's the updated program that allows you to store the players for the starting lineup using a list of lists:

POSITIONS = ('C', '1B', '2B', '3B', 'SS', 'LF', 'CF', 'RF', 'P')

lineup = []

def display_lineup():

   print("Player\tPosition\tAt Bats\tHits\tBatting Average")

   for player in lineup:

       name, position, at_bats, hits = player

       if at_bats == 0:

           avg = 0

       else:

           avg = hits / at_bats

       print(f"{name}\t{position}\t\t{at_bats}\t{hits}\t{avg:.3f}")

def add_player():

   name = input("Name: ")

   position = input("Position: ")

   if position not in POSITIONS:

       print("Invalid position. Try again.")

       return

   at_bats = int(input("At bats: "))

   hits = int(input("Hits: "))

   lineup.append([name, position, at_bats, hits])

   print(f"{name} was added.")

def remove_player():

   name = input("Name: ")

   for player in lineup:

       if player[0] == name:

           lineup.remove(player)

           print(f"{name} was removed.")

           return

   print(f"{name} is not in the lineup.")

def move_player():

   name = input("Name: ")

   for i, player in enumerate(lineup):

       if player[0] == name:

           current_index = i

           break

   else:

       print(f"{name} is not in the lineup.")

       return

   new_index = int(input("New lineup number: ")) - 1

   lineup[current_index], lineup[new_index] = lineup[new_index], lineup[current_index]

   print(f"{name} was moved.")

def edit_position():

   name = input("Name: ")

   for player in lineup:

       if player[0] == name:

           position = input("New position: ")

           if position not in POSITIONS:

               print("Invalid position. Try again.")

               return

           player[1] = position

           print(f"{name} was updated.")

           return

   print(f"{name} is not in the lineup.")

def edit_stats():

   name = input("Name: ")

   for player in lineup:

       if player[0] == name:

           at_bats = int(input("At bats: "))

           hits = int(input("Hits: "))

           player[2] = at_bats

           player[3] = hits

           print(f"{name} was updated.")

           return

   print(f"{name} is not in the lineup.")

while True:

   print("""

   MENU OPTIONS

   1 Display lineup

   2 Add player

   3 Remove player

   4 Move player

   5 Edit player position

   6 Edit player stats

   7 Exit program

   """)

   choice = input("Menu option: ")

   if choice == '1':

       display_lineup()

   elif choice == '2':

       add_player()

   elif choice == '3':

       remove_player()

   elif choice == '4':

       move_player()

   elif choice == '5':

       edit_position()

   elif choice == '6':

       edit_stats()

   elif choice == '7':

       print("Bye!")

       break

   else:

       print("Invalid option. Try again.")

The program uses a list of lists to store each player in the lineup. Each sublist contains the player's name, position, at bats

Explanation:

Answer:

The main advantage of a file-based approach to manual data management is that it is simple and easy to understand. Each file is used to store a specific type of data, and the files are stored in a logical hierarchy. This makes it easy to find the data you need, and it also makes it easy to keep track of the data.

Another advantage of a file-based approach is that it is very flexible. You can easily add new files or modify existing files to meet your needs. This makes it a good choice for small businesses or organizations that need to be able to adapt quickly to changes.

Finally, a file-based approach is very cost-effective. You don't need to purchase any special software or hardware, and you can easily set it up yourself. This makes it a good choice for businesses or organizations that are on a tight budget.

However, there are also some disadvantages to a file-based approach. One disadvantage is that it can be difficult to manage large amounts of data. Another disadvantage is that it can be difficult to keep track of changes to the data. Finally, a file-based approach can be less secure than other methods of data management.

Overall, a file-based approach to manual data management is a simple, flexible, and cost-effective way to store data. However, it is important to weigh the advantages and disadvantages before deciding if it is the right choice for your needs.

Answer:

"The Future Doesn't Need Us" is an essay by computer scientist and author Bill Joy, published in 2000 in Wired magazine. In the essay, Joy expresses his concern about the potential dangers of emerging technologies such as nanotechnology, robotics, and artificial intelligence.

Joy argues that while these technologies have the potential to solve many of the world's problems, they also pose significant risks, such as the possibility of self-replicating machines that could cause widespread destruction. Joy suggests that these risks may outweigh the benefits, and that we should proceed with caution when developing these technologies.

Joy also expresses concern about the potential loss of human control over technology. He argues that as machines become more advanced and intelligent, they may become capable of making decisions without human input, leading to a loss of control over our own creations.

Overall, Joy's essay suggests that we need to carefully consider the implications of emerging technologies, and that we should not blindly pursue technological progress without considering the potential risks and consequences.

Assuming you possess a table entitled "employees" consisting of columns "employee_id", "name", and "salary", to retrieve all employees and their corresponding salaries,

SELECT name, salary FROM employees;

To filter by an individual employee_id, utilize:

SELECT name, salary FROM employees WHERE employee_id = [employee_id];

For sorting results in descending order of salary, employ:

SELECT name, salary FROM employees ORDER BY salary DESC;

Read more about SQL here:

https://brainly.com/question/25694408
#SPJ1

The Python script prompts the user to input a number via keyboard and saves it as "number":

number = input("Enter a number: ")

Keep in mind that the string nature of this input() function implies that you must convert it into a numerical form, such as int() or float(), if mathematical manipulation is desired.

Python is a comprehensive, high-level interpreted programming language that saw its genesis dating back to 1991. Noted for its usability, readability and versatility, this widespread language has established usage in various sectors such as web development, data science, machine learning and more.

What's more, Python has an extensive standard library and an affluent pool off community members who have donated to an array of open-source packages and tools.

Read more about programs here:

https://brainly.com/question/26134656
#SPJ1

select si.*

from saleitem si join product p

on si.productid=p.productid

where category='sneakers'

and color='Green'

The SaleItem table is a database table that is typically used in e-commerce systems to store information about items that have been sold. Each record in the SaleItem table represents a single item that has been sold, and the table contains information about the sale, such as the date of the sale, the quantity sold, and the price at which the item was sold.

In this schema, the sale_item_id column is a unique identifier for each sale item record. The sale_id column is a foreign key that references the Sale table, which contains information about the sale as a whole. The item_id column is a foreign key that references the Item table, which contains information about the item being sold. The quantity column indicates how many of the item were sold, and the price column indicates the price at which each item was sold.

Learn more about table on:

https://brainly.com/question/29589712

#SPJ1

According to the consumer's demand for both agility and size, two compelling SSD options emerge -- the Samsung 970 EVO Plus and the WD Black SN850.

The Samsung 970 EVO Plus boasts sequential reads reaching 3500MB/s as well as writes up to 3300MB/s; its 2TB product is priced at $349.99 on Samsung's website.

When it comes to the WD Black SN850 ,it exhibits brisk sequential readings of 7000MB/s and writings of 5300MB/s; matching the former, this 2TB model also carries a cost of $499.99 through Western Digital's website.

Overall prices for the Samsung 970 EVO Plus and the WD Black SN850 stand at $349.99 and $499.99 respectively. More visuals and precise details can be found on the relevant webstores.

Read more about SSD here:

https://brainly.com/question/28476555

#SPJ1

A hyperlink's intent within a presentation is to establish a connection between the audience, a new slide, file, or webpage which contains supplementary information related to the subject matter under discussion.

The judicious application of hyperlinks allows presenters to steer attendees toward pertinent resources including research-based studies, images and infographics, videos or even interactive content that maximizes facts-retention by accomplishing engagement.

Employing hyperlinks further aids organizers in seamlessly maneuvering across several slides, an external domain without disturbing the discourse's natural rhythm, thus enabling effective tracking of subjects and a clearer message delivery.

Read more about hyperlinks here:

https://brainly.com/question/29227878

#SPJ1

The program based on the information will be:

# Declare and create two arrays called nums1 and nums2 to eventually store 15 integers each.

nums1 = [0] * 15

nums2 = [0] * 15

# Declare a third array called nums3 and assign to it 15 values of your choice (from 1 to 30 – BUT NOT in sorted order)

nums3 = [25, 12, 6, 2, 30, 19, 14, 3, 7, 11, 26, 9, 28, 16, 21]

In this example code, we first create two arrays nums1 and nums2 with 15 elements each, all initialized to 0.

Then we declare a third array nums3 and assign it 15 values of our choice, as instructed in the prompt.

Learn more about program on

https://brainly.com/question/26642771

#SPJ1

A lower bit rate means that fewer bits of data are transmitted per second, resulting in a lower quality video

A decreased bit rate signifies that a smaller quantity of bits are sent each second, leading to a lower-caliber video. Videos with a minor bit rate usually feature choppy, pixelated motion garnered due to the compression of the footage.

This compression detracts from the amount of information transported, causing a decrease in detail and definition. Alternatively, videos possessing an advanced bit rate would encompass larger documents and a more continuous succession of motion, given that more data is disseminated per second - thereby making for a higher quality video. The increased bit rate enables for increased clarity as well as improved resolution to be persisted within the clip.

Read more about bit rate here:

https://brainly.com/question/30456680

#SPJ1

In a parallel circuit, the total resistance D. is less than the sum of all the resistances.

When there are several paths for the electric current to travel through, a circuit is said to be parallel. A steady voltage will exist over the whole length of the components in the parallel circuits.

With this in mind, one can see that the correct answer from the list of answer choices is option D which sasys that the total resistance D. is less than the sum of all the resistances.

Read more about resistance here:

https://brainly.com/question/17563681

#SPJ1

Answer:

groups consisting of people from different functional areas of the company – for example, marketing.

The  free presentation software are:

Canva is a clear design platform that involves a presentation maker finish. It offers a user-friendly connect and a variety of templates, images, and design pieces that students can use to conceive engaging and visually attractive presentations.

Also, Prezi is a cloud-located presentation software that allows pupils to create mutual and dynamic presentations. It offers a zoomable tarp where graduates can add text, representations, and videos and create a non-undeviating presentation flow.

Learn more about software from

https://brainly.com/question/28224061

#SPJ1

Answer:

Sure, here is a Python program to calculate a year:

```python

# Import the datetime module

import datetime

# Get the current date and time

current_date = datetime.datetime.now()

# Get the year from the current date and time

year = current_date.year

# Print the year

print("The current year is", year)

```

Output:

```

The current year is 2023

```

Explanation:

If we use the decision tree algorithm to learn a decision tree from this dataset, tje feature that would be used as the split for the root node is C. h₃(x)

The decision tree algorithm uses a heuristic called "information gain" to determine the best feature to use for the split at each node.

The feature with the highest information gain is selected as the split. Information gain measures the reduction in entropy or impurity of the target variable that results from splitting the data based on a particular feature.

Based on the information, the correct option is C.

Learn more about algorithms on

https://brainly.com/question/24953880

#SPJ1

Answer:

Here are some tips on how to improve your projection, articulation, intonation, and rate:

Projection: Speak loudly enough to be heard by everyone in the room, but not so loudly that you are shouting.

Articulation: Pronounce your words clearly and distinctly.

Intonation: Vary the pitch of your voice to add interest and emphasis to your speech.

Rate: Speak at a rate that is comfortable for you and that allows your audience to follow your speech.

It is important to practice these skills regularly so that you can use them effectively in any situation.

Here are some additional tips for improving your speaking skills:

Be aware of your body language. Make eye contact with your audience, and use gestures to emphasize your points.

Be confident. Believe in yourself and your message, and your audience will be more likely to believe in you too.

Practice, practice, practice! The more you speak, the better you will become at it.

Keep practicing! Nobody ever gets better at anything overnight. Every single person who is great at soccer has put in hours of practice!

(a) 6.964 is the intercept of the regression equation, representing the estimated level of autonomy when age is zero.

(b) 0.06230 is the slope of the regression equation, representing the estimated change in autonomy for each one-unit increase in age.

(c) The regression equation has a weak positive correlation (r = 0.28) between age and autonomy, indicating that age explains only a small proportion of the variance in autonomy.

(d) The likely level of autonomy for someone aged 54 can be estimated by plugging in 54 for age in the regression equation: autonomy = 6.964 + 0.06230(54) = 10.227.

(e) In R, you could generate this regression information using the lm() function, specifying the dependent variable (autonomy) and the independent variable (age) in the formula argument. The summary() function can be used to obtain the regression coefficients and correlation coefficient (r).

Read more about regression here:

https://brainly.com/question/17004137

#SPJ1

The appropriate image to illustrate the information about the circuit is attached

To convert a circuit using NAND gates, you can follow these steps:

Identify all the gates in the circuit that are NOT NAND gates.

Replace each of these gates with their equivalent NAND gate circuit using De Morgan's theorem, which states that:

The negation of an AND gate is a NAND gate with all inputs negated.

The negation of an OR gate is a NAND gate with all inputs negated and the output negated.

If there are any NOT gates in the circuit, you can replace them with a NAND gate with one input tied to logic 1 (or Vcc) and the other input connected to the input of the NOT gate.

Learn more about Circuit on:

https://brainly.com/question/30018555

#SPJ1

A Mealy machine and a Moore machine can be designed to detect the sequence "1011". For the Mealy machine, states represent the matched part of the sequence, and output depends on transitions.

For the Moore machine, states also represent the matched part, and output depends on states.

To design a Mealy machine, follow these steps:

1. Create states (S0, S1, S2, S3) representing matched parts of the sequence.

2. Add input edges and output labels for each transition (0 or 1).

3. For correct input, transition to the next state (e.g., S0 -> S1 on input 1).

4. For incorrect input, transition back to the appropriate state.

5. Set output 1 when the final state is reached (S3), and 0 otherwise.

Learn more about transition on:

https://brainly.com/question/17998935

#SPJ1

An example of how computer programming is applied in real world situations is the use of traffic lights.

The traffic flow data is processed by the computer to establish the right sequence for the lights at junctions or ramps. The sequencing information is sent from the computer to the signals via communications equipment.

INRIX Signal Analytics is the first cloud-based solution that harnesses big data from linked automobiles to assist traffic experts in identifying and understanding excessive delays at signalized junctions throughout the country — with no hardware or fieldwork required.

Learn more about computer programming:
https://brainly.com/question/14618533
#SPJ1

In this problem, we are given that Mr. Murphy has 2 boxes of pens in his office, with 5 bundles of pens in each box, and 50 pens in each bundle. We can find the total number of pens Mr. Murphy currently has by multiplying the number of boxes by the number of bundles in each box, and then by the number of pens in each bundle. This gives us:

2 boxes x 5 bundles per box x 50 pens per bundle = 500 pens

Next, we are told that Mr. Murphy wants to have 750 pens available for the fundraiser. To determine how many more pens he needs to order, we can subtract the number of pens he currently has from the total number of pens he wants to have:

750 pens - 500 pens = 250 pens

This tells us that he needs to order 250 more pens to have a total of 750 pens available for the fundraiser.

Mr. Murphy currently has 500 pens in his office because 2 x 5 x 50 = <<2*5*50=500>>500.

Mr. Murphy needs to order 250 more pens because 750 - 500 = <<750-500=250>>250.

Therefore, Mr. Murphy should order 250 more pens.

Match the president name and he expanded:

On March 15, 1767, Andrew Jackson was born; he passed away on June 8, 1845. He was to stand in for the "corrupt bargain" that, in his opinion, cost him the presidency and gave him the drive to win the next election no matter what.

According to the various president are the various decision. The president is the used of the power to take the decision.

Franklin Roosevelt: The veto power and the political reasons.

Harry Truman: The used right to declare war in Korea.

Andrew Jackson: president power, executive orders.

As a result, the significance of the Andrew Jackson are the aforementioned.

Learn more about on Andrew Jackson, here:

brainly.com/question/27920494

#SPJ1

The question seems to be incomplete, the complete question will be:

Drag the tiles to the correct boxes to complete the pairs.

Match each president’s name to the correct description of how he expanded.

Franklin Roosevelt, Harry Truman, Andrew Jackson

presidential power.

Issued the most

executive orders

Used veto power for

political reasons

Bypassed Congress to

declare war in Korea

Answer:

1.

Design the Data Structure:

a. Format for storing student records:

We can store student records in a table format, where each row represents a student record, and the columns represent the different attributes, i.e., name, ID number, major, and GPA.

b. Data types for each field:

For each field, we can use the following data types:

c. Operations that the data structure should support:

e. Diagram showing how the different data structures will be used together:

See Attachment

Implement the Data Structure:

a. Implementation of each data structure to store the student records:

# Array implementation

MAX_RECORDS = 100

students = [None] * MAX_RECORDS

# Linked List implementation

class StudentNode:

   def __init__(self, name, id_num, major, gpa):

       self.name = name

       self.id_num = id_num

       self.major = major

       self.gpa = gpa

       self.next = None

class StudentLinkedList:

   def __init__(self):

       self.head = None

   def insert(self, name, id_num, major, gpa):

       new_node = StudentNode(name, id_num, major, gpa)

       if self.head is None:

           self.head = new_node

       else:

           curr = self.head

           while curr.next is not None:

               curr = curr.next

           curr.next = new_node

# Stack implementation

class StudentStack:

   def __init__(self):

       self.stack = []

   def push(self, name, id_num, major, gpa):

       self.stack.append((name, id_num, major, gpa))

   def pop(self):

       if len(self.stack) > 0:

           return self.stack.pop()

       else:

           return None

b. Functions to insert, delete, and search student records:

# Insert a new student record

def insert_record(name, id_num, major, gpa):

   # Insert into array

   for i in range(len(students)):

       if students[i] is None:

           students[i] = (name, id_num, major, gpa)

           break

   # Insert into linked list

   student_list.insert(name, id_num, major, gpa)

   # Insert into stack

   student_stack.push(name, id_num, major, gpa)

# Delete an existing student record

def delete_record(id_num):

   # Delete from array

   for i in range(len(students)):

       if students[i] is not None

1)Design the Data Structure:

We can store student records in a table format, where each row represents a student record, and the columns represent the different attributes, i.e., name, ID number, major, and GPA. Other part is discussed below:

An array can be used to store the student records in a contiguous block of memory. We can use an array to store the student records when we know the maximum number of records that we will store in advance.

Linked List: A linked list can be used to store student records in a non-contiguous block of memory. We can use a linked list to store the student records when we don't know the maximum number of records that we will store in advance.

Stack: A stack can be used to store the student records when we want to retrieve the most recently added record first. Diagram showing how the different data structures will be used together:

Implement the Data Structure:

a. Implementation of each data structure to store the student records:

# Array implementation

MAX_RECORDS = 100

students = [None] * MAX_RECORDS

# Linked List implementation

Learn more about array on:

https://brainly.com/question/30757831

#SPJ2

Answer:t depends on whether or not the website is secure and it's a well-known website. Or it could be a scam. Unfortunately we all have to worry about that now. If ...

4 answers

·

12 votes:

if you give them your email address along with your password of course t

Explanation:

Answer:  The Caesar shift cipher is a simple encryption technique where each letter in the plaintext is shifted a certain number of places down the alphabet.

To decode the encrypted message "XQGHU WKH VWDWXH" using the Caesar shift cipher, we need to shift each letter three places up the alphabet. For example, A becomes D, B becomes E, and so on.

Applying this shift to each letter in the message, we get the following plaintext message:

"UPDATE THE STASH"

Therefore, the package has been left in a stash that needs to be updated.

Explanation:

Yes, one can have or should one own a smart home device

Some security issues that one can find bothersome with these types of devices are:

Smart home tools offer usefulness and can help create growth easier, but they further create freedom risks that should be deliberate.

Some freedom issues so that find bothersome accompanying smart home tools contain:

Lastly, in terms of Privacy concerns: Smart home ploys may accumulate individual dossier, such as custom patterns and choices, that could be joint accompanying after second-party parties for point or direct at a goal buildup or added purposes.

Learn more about  security issues  from

https://brainly.com/question/29477357

#SPJ1

Answer:

import turtle

Jane = turtle.Turtle()

bar1 = int(input("What is the height of the first bar?" ))

bar2 = int(input("What is the height of the second bar?" ))

bar3 = int(input("What is the height of the third bar?" ))

bar4 = int(input("What is the height of the fourth bar? "))

Jane.left(90)

def bar(height):

   if height > 200:

       height = 200

   Jane.forward(height)

   Jane.left(90)

   Jane.forward(20)

   Jane.left(90)

   Jane.forward(height)

   Jane.right(180)

bar(bar4)

bar(bar3)

bar(bar2)

bar(bar1)