5.12. Consider the AIRLINE relational database schema shown in Figure 5.8 , which describes a database for airline flight information. Each FLGHT is identified by a Flight_number, and consists of one or more FLIGHT_LEGs with Leg_numbers $1,2,3$, and so on. Each FLIGHT_LEG has scheduled arrival and departure times, airports, and one or more LEG_INSTANCEsone for each Date on which the flight travels. FAREs are kept for each FLIGHT. For each FLIGHT_LEG instance, SEAT_RESERVATIONs are kept, as are the AIRPLANE used on the leg and the actual arrival and departure times and airports. An AIRPLANE is identified by an Airplane_id and is of a particular AIRPLANE_TYPE. CAN_LAND relates AIRPLANE_TYPEs to the AIRPORTs at which they can land. An AIRPORT is identified by an Airport_code. Consider an update for the AIRLINE database to enter a reservation on a particular flight or flight leg on a given date. a. Give the operations for this update. b. What types of constraints would you expect to check? c. Which of these constraints are key, entity integrity, and referential integrity constraints, and which are not? d. Specify all the referential integrity constraints that hold on the schema shown in Figure 5.8 .

AIRPORT \begin{tabular}{|l|l|l|l|} \hline Airport code & Name & City & State \\ \hline \end{tabular} FLIGHT \begin{tabular}{|l|l|l|} \hline Flight_number & Airline & Weekdays \\ \hline \end{tabular} FLIGHT_LEG \begin{tabular}{|l|l|l|r|} \hline Flight_number & Leg_number & Departure_airport_code & Scheduled_departure_time \\ \hline & Arrival_airport_code & Scheduled_arrival_time \\ \hline \end{tabular} LEG_INSTANCE \begin{tabular}{|c|c|c|c|c|c|} \hline Flight_number & Leg_number & Date & Number_of_available_seats & \multicolumn{2}{|c|}{ Airplane_id } \\ \hline Departure_airport_code & Departure_time & Arrival_airport_code & Arriva__time \\ \hline \end{tabular} FARE \begin{tabular}{|l|l|l|l|} \hline Flight_number & Fare_code & Amount & Restrictions \\ \hline \end{tabular} AIRPLANE_TYPE \begin{tabular}{|l|l|l|} \hline Airplane_type_name & Max_seats & Company \\ \hline \end{tabular} CAN_LAND \begin{tabular}{|l|l|} \hline Airplane_type_name & Airport_code \\ \hline \end{tabular} AIRPLANE Figure 5.8 The AIRLINE relational database schema.

Using LC-3 Programming Exercise 1 Use .BLKW to set up a remote array of 10 values, starting at memory location x4000, as in lab 3. Now programmatically populate the array with the numbers 0 through 9 (note - NOT the characters '0' through '9'!) – i.e. hard-code just the first value (0), then calculate the rest one at a time, storing them in the array as you go. Remember the proper way of setting a register to 0! After you've stored them all, grab the seventh value (i.e. 6) and store it in R2. Clearly, you can't access this location via a label, so you'll need its actual address. How will you obtain that? And how will you use that address to get the value stored there? As always, step through your program and examine the values as they are stored in the array, and examine the final value stored in R2, to make sure your program works as expected. Exercise 2 You'll notice that Exercise 1 didn't ask you to output to console the array you built. Why not? Because as you know by now, numbers are not characters! So now copy your exercise 1 code into lab4_ex2.asm, and add an output loop, making it output the characters corresponding to the numbers stored in your array. Exercise 3 Let's try another modification of our well-used array program from Exercise 1: This time, instead of calculating and storing the numbers from 0 to 9 in the array, calculate and store the first ten powers of 2, starting with 20 = 1 in array index 0. Finally, grab the seventh value (26) from the array, and store it in R2. In order to do this, you will have to figure out how to calculate powers of 2. Some hints: Mathematically speaking: How do I obtain 2n+1 if I know 2n? What LC-3 operation could I use to multiply a number by 2? As always, place a breakpoint in your program, and step through it, examining the values as they are being stored in the array, and examine the final value stored in R2,  to make sure your program works as expected. Pay attention to both the decimal and hex representations of the values being stored. You already understand that you can't simply output the values in the array to the console “as is”, so we have to manipulate them somehow to turn them into characters. But this time all but the first four are multi-digit numbers when represented as decimal values, so our trick from the last exercise won't work – it can only convert the numbers from 0 to 9 into the single-digit ascii characters '0' through '9'.  Exercise 4 For now, we will instead observe what happens if we attempt to do what we just said can't be done - output the contents of the array "as is", i.e. as if they were ascii codes (which they are not!). Copy your exercise 3 code into your lab4_ex4.asm file, and add a second loop that loads the content of each element of the array into R0 and outputs it to the console using OUT. Now place a breakpoint at the start of your display loop and step through it: You will need to keep an eye on the Console to understand what is going on!! Please add comments!!!

Write an assembly code that performs the following four tasks: enable the interrupt number 31, and sets its priority bits to 2, and clears its pending bit disable the interrupt 31 (Hints: Each interrupt has one enable bit, one pending bit, and one byte of priority.)

7. The number of surface flaws in plastic panels used in the interior of automobiles has a Poisson distribution with mean of 0.04 flaws per square foot of plastic panel. Assume automobile interior contains 10 square feet of plastic panel.(a) What is the probability that there are no surface flaws in an auto's interior?(b) If 10 cars are sold to a rental company, what is the probability that none of the 10 cars has any surface flaws?(c) If 10 cars are sold to a rental company, what is the probability that at most two cars have any surface flaws?

Please DO NOT respond to this question by copy/pasting the code provided elsewhere on the site, none of those work. Thanks. Virtual Memory Lab This lab project addresses the implementation of page-replacement algorithms in a demand-paging system. Each process in a demand-paging system has a page table that contains a list of entries. For each logical page of the process, there is an entry in the table that indicates if the page is in memory. If the page is in memory, the memory frame number that page is resident in is indicated. Also, for each page, the time at which the page has arrived in memory, the time at which it has been last referenced, and the number of times the page has been referenced since the page arrived in memory are maintained. The page table data structure is a simple array of page-table entries (PTEs). Each PTE contains five fields as defined below: struct PTE { int is_valid; int frame_number; int arrival_timestamp; int last_access_timestamp; int reference_count; } Each process in the system has a page table that is simply an array of PTEs. Each process also has a pool of frames that is allocated. The frame pool for a process is represented as an array of integers, where each Integer represents the frame number of a frame that is free and is available for use by the process. Note that in order to get the frame number in the pool, you first need to access the integer in the array. This lab project aims to exercise the various policies for page replacement. In particular, we study the following three page-replacement policies: First-In-First-Out (FIFO) Least-Recently-Used (LRU) Least-Frequently-Used (LFU) In order to implement the above policies, we need to develop corresponding functions that process page accesses for a process. That is, for each process, given its page table, a logical page number being referenced and the free frame pool of the process, the functions should determine the memory frame number for the logical page. Also, the functions should modify the page table and the free frame pool appropriately. The details of the functions with respect to the different policies are described below. You need to develop code for these functions that implement the specifications. Place the code in a file called virtual.c. You should include the oslabs.h file.

Not less than 250 words 1.A company has a choice of four different modes of foreign market entry. Briefly describe each of these modes, and explain when each would be the best option. 2.Define the term global brand. How are global brands important?

7-Eleven Malaysia Holding Berhad's annual report for the fiscal year ending 2021 is available at https://www.7eleven.com.my/financial-reports. (At least two years of comparable financial statements are required.) a) Assess 7-Eleven’s financial position for year 2020 and 2021 according to i) liquidity position, and how the liquidity position has changed over time from 2020 to 2021. (6 marks) ii) asset management position, and how its asset management efficiency has changed over time. (6 marks) iii) debt management position, and how its debt management has changed over time. (6 marks) iv) profitability ratios, and how its profitability position has changed over time. (6 marks) v) market value ratios, and how its valuation has changed over time. (6 marks) b) Calculate 7-Eleven’s ROE as well as the industry average ROE, using the DuPont equation. From this analysis, how does 7-Eleven’s financial position. (10 marks) c) Write your opinion on what you think would happen to its ratios if the company initiated cost-cutting measures that allowed it to hold lower levels of inventory and substantially decreased the cost of goods sold. No calculations are necessary. Think about which ratios would be affected by changes in these two accounts. (10 marks)