1. Load the large stocks dataset ) into HDFS and use the dataset to create a Hive table using the location attribute. 2. Write a SQL command to find the stocks with average daily volume larger than 1 million shares. 3. Write a Hive query to find the top 3 stocks by volume for the […]
MSCS2103: Systems Programming 200 Points 1) Using the ASCII table above, convert the letters ‘ABC’ to a binary representation. 2) What is ASCII? What problem does it solve? Be sure to name the limitations of ASCII. 3) What is a flip-flop, and what is it used for? Name a type of flip-flop. 4) Draw the […]
Consider a system described by the transfer function: G(s)={k(s+1.5)}/{s^2+(1+b/99)s+4} where b equals the last two digits of your student number . A) Provide a FULL and comprehensive system analysis of the continues system in both time and frequency domain . B) Choose a suitable sampling rate (T). Explain why? C) Obtain the discrete transfer function […]
Assignment1: Advanced Analog Mixed Signal Design MEL ZG 625 1. For the CMOS operational amplifier shown in calculate the open-loop voltage gain, unity gain bandwidth, and slew rate. Assume that the gate of M9 is connected to the positive power supply and that the W/L of M9 has been chosen to cancel the right half-plane […]
1/ Draw a class diagram and entity-relationship diagram for Recycle website project depicting of the system based on the use case diagram and process flow diagrams. 2/ each diagram must be followed up with an explained document
Introduction You are in the DevOps group at a government agency where the organization runs a case management application. They are having performance problems running the application in-house (a web server in their own data center), and there is too much downtime. They are looking to your advice about whether they need to procure one […]
Paper/Pen user: Scan or photograph your solutions on papers, then use “Insert\Photo” to place your answers as digital images in this word template. Tablet/Pad user: You may work and derive the solutions digitally on this document freely. Submit a PDF file to Canvas, named as: LastNameFirstInitial_HW#4.pdf. For example, my first name is Shih-Feng and my […]
Design a 4th – order, low-pass Butterworth active filter with a critical frequency of 2kHz. Use the Equal-Value, Sallen-Key op amp circuit for each stage. Capacitor and resistor values must be from the standard value tables shown below. The capacitor values must be in the range of 1000pF to 1uF and the resistors must be […]
Create the Fact and Dimension table attribute and the ER data model diagram for the attributes listed below. TRANSACTIONPARTITIONKEY TRANSACTIONKEY DAYPARTKEY TRANSACTIONDATEKEY BUSINESSDATEKEY PROFITCENTERKEY STOREKEY STORESTATUSKEY ORGANIZATIONKEY PERIODICORGANIZATIONKEY REGISTERKEY PTXGUID CHARGES DEBIT DISCOUNTS TAXES REMITTANCE GUESTCOUNT DRAWERKEY DEBITAMT REFUNDAMT SSSCOUNT STORESTATUS2KEY PROFITCENTERKEY_ORIG CATERINGKEY MISCCHARGES CREATEDTIME
1. Briefly describe the steps that are used to ascertain whether a particular metal alloy is suitable for use in an automobile valve spring. 2. Explain how the tensile strength and fatigue strength of a particular metal affect the materials selection process for an automobile valve spring. 3. For a steel alloy material in a […]
