Carmen Quiz 3 - Chapter 3 - Spreadsheet Design_ AU23 CSE 2111 - Spreadsheets & DBs (7288)

(b) Figure 1, shows an ARM assembly program, which finds the most positive and negative values in a list of 16-bit (half-word) value in data memory (TABLE). The values are in two's complement representations. By examining the program, answer the following questions: (i) Find the errors in the program and make necessary corrections. Do not insert any additional line in the program. (ii) How many bytes does 'TABLE' occupy? (iii) What are the values loaded in the register R2 and R4? (iv) Determine the values of the flags N, Z, C and V. (v) Modify the program such that the numbers in 'TABLE' are represented in 'word' length.

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma Junior College degree Master's degree

c) Given the following tables: Table : TRUCK Truck Num Base_Code 501 Туре_Сode 1 Truck Miles 5676.89 12232.67 9886.68 23445.76 454.98 Truck SerialNum AA-322-1222-W11 AV-678-4545-023 FR-456-1123-R45 AD-213-7654-WQ XV-987-1234-SQ 1001 1002 502 501 501 502 1. 1003 1004 1005 2 13 Table: BASE Base Code 501 502 503 Base City Jasin Shah Alam Kuala Kangsar Perak Base State Base_Postcode Base_Manager 77000 40000 33000 Malacca Selangor Fattah Aziz Michael Faraday Benjamin Table: TYPE Туре Сode Tyуре Description 1 2. Single box, double-axie Single box, single axie Tandem trailer, single axie 3. Describe the type(s) of relationship(s) between TRUCK and BASE relations. Identify the entity integrity (if any) for each table. Answer YES or NO, and then explain your answer. il) Draw the ER Diagram that corresponds to the above tables. Include all the appropriate connectivity and cardinalities of the relationships.

Making a DataFrame Create a dataframe pd that contains 5 rows and 4 columns, similar to the one given below: Col1 Col2 Col3 Col4 7 5 707 60 4 1 2 3 5 4 5 5 8 6 7 Note: 7 78 78 18 88 - Print only the first two rows of the dataframe. - Print the second column. - Change the name of the third column from "Col3" to "XYZ". - Add a new column to the dataframe and name it "Sum". - Sum the entries of each row and add the result in the column "Sum". Please provide PYTHON (ANACONDA) code for above task.

:  STONEHENGE ENGINEERING WORKS: Stonehenge Engineering Works is a small company that specializes in complex engineering consulting projects.  Most Engineering projects need large data transaction. The company is moving into new offices and ask you to design their data communication network.  They are going to have two divisions in two different office sites in the same building, (two story office building) Engineering division in the first floor : They have a staff of 10 engineers (which is expected to grow  over the next five years. And, additional new 15 PCs will be needed ) and the Database for the product development.  Engineering division will be using 3D design and online collaborations tools which require large bandwidth and fast data communication. Management division in the second floor : There are 20 management and clerical employees who also need network connections, but whose needs are less intense. This site has database for the clients as well. All employees in the…

https://www.bartleby.com/questions-and-answers/jobs-burst-time-arrival-time-j1-17-j2-1-j3-30-15-j4-15-17-j5-20-30-1.-which-job-is-executed-first-2./667de578-d666-4b96-ba55-6ab93be41458

Create the following table in MySql and share the code

For the following, write the citation in IEEE format:                                         author = { Silvio Labbate }, Title = {Italy and the development of European energy policy: from the dawn of the integration process to the 1973 oil crisis},             Journal = {European Review of History: Revue européenne d'histoire},             Volume = {20},          number = {1},            pages = {67-93},        year = {2013},   author="Heinberg, Richard", Title="The Energy Wildcard: Possible Energy Constraints to Further Urbanization",             Book Title="State of the World: Can a City Be Sustainable?",        year="2016",             Publisher="Island Press/Center for Resource Economics",             Address="Washington, DC", pages="65--73",   Title of Web Page : Microwave signals turned into electrical power Year, Month, Day: 2013, November, 11th Authors name: BBC News             Available URL: http://www.bbc.co.uk/news/technology-24897584

Code for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…

1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)

Location Invoice Submitted by the Vendor Invoice on Record Invoice Amount Remarks Tax Manila 010001 010001 18,086.00     Makati 000502 000502 28,000.00     Makati 000703 003703 16,216.00     Caloocan 004004 004004 2,000.00     Mandaluyong 008005 008005    8,216.00     Makati 006006 006006    8,764.00     Quezon City 003007 003007    8,764.00     Quezon City 007008 004008    8,764.00     Mandaluyong 001009 001009    8,764.00     Manila 008010 008010    8,790.00     Caloocan 004012 005011 45,000.00     Caloocan 002011 008017 30,000.00     Quezon City 008017 005311 5,000.00     Quezon City 005311 008017 15,000.00     Manila 001015 002011 25,000.00     Summary: Total Invoice Amount for Manila   Total Invoice Amount for Quezon City and “Not Found”   Total…

Choose the best answer from following answers:C(x): x is taking CSE 105. M(x):x is a CSE major. ∀×(M(x)^C(x)) in English is a) Every student is a CSE major and they all are taking CSE 105b) Every CSE student is taking CSE 105c) None of the above

SQL 2019 Answer choices (a, b, c, d, and e) indicate whether a certain data type supports the UTF-8 encoding or not.

Sample invoice is given as follows: International Conference on Mathenatical Sciences and Technology (MathTech) Invoice Date Invoice No Name : 20 January 2022 : 0001 : Muhammad Irfan Ali : Presenter Category Accommodation (Y/N) : Y Conference Fee Acconnodation Fee Total Amount Due (RM) : 1290.00 : 990.00 : 300.00 Terms & Conditions Payment is due within 30 days. Please make payment via online banking to Maths USM (RHB: 1234554321) You are encouraged to add on extra features to your program. Proceed to Part 2 only if you have completed Part 1. Part 2: Create Invoice via File Processing a. Modify the program in Part 1 to read in the file provided, File.txt. b. Use array structure in your program. c. Print all 5 receipts continuously to Dutput.txt. amusm.my Sie samms Malaysia

DB - Normalization   Question # 1 Patient Medication Form   Patient Number:  P10034 Full name: Elbert McDonald                 Ward Number: Ward 11 Bed Number: B4                                    Ward Name: Orthopaedic   Drug Number Name Description Dosage Method of Admin Unit per Day Start Date Finish Date 10223 10334 10223 Morphine Tetracyclene Morphine Pain Killer Antibiotic Pain Killer 10mg/ml 0.5mg/ml 10mg/ml Oral IV Oral 50 10 10 24/03/04 24/03/04 25/04/05 24/04/05 17/04/04 02/05/06   Examine the Patient Medication Form above: Put the above form into a relation schema Identify the functional dependencies. Describe and illustrate the process of normalization to produce 3NF relations.   Question#2: Given the following Theatre Database form:    No.of seats:500                          Owner: J.Martin         Year Founded: 1890 Owner’s Phone: 2347756         - - - - -   Play Name Play Type No. of performances…

Describe Process Specification and techniques for the following diagram. Please follow the same format as attached in this pdf: https://drive.google.com/file/d/1vnE5KJi3K1T74hU1uDuqdFfsd90oX11h/view?usp=sharing There is same question with correct format: https://www.bartleby.com/questions-and-answers/describe-process-specification-and-techniques-for-the-following-diagram.-please-follow-the-same-form/01069b75-4a39-44f7-909a-ac99df19570c

Consider the following Unix Shell dialogue: s echo (mdir C214; cd c214;pwd) >Ceng214 $ cat Ceng214 #Box 1 Ab bb b Ceng214 #Box2 -r-xr--r-1 bilgen 21 Jun 29, 2021 10:38 Ceng214 $ (a=aaa; b=bbb; export a; echo Sb) #Box3 $ echo $a $b #Box4 s Ceng214 #Box5 $ pwd #Box6 Mark all the correct statements about the contents of the empty boxes, below: O Box4 contains: $a O Box3 contains: $b O Box4 contains: $b O Box1 contains: $ O Box6 contains: pwd O Box5 contains: Ceng214 O Box6 contains: Ceng214 O Box3 contains: echo $b O Box1 contains: C214 O Box6 contains: Bilgen O Box1 contains: mdir C214;cd C214;pwd O Box2 contains: $ls -I Ceng214 O Box2 contains: Schmod u+x,u-w Ceng214 (... OR $chmod 544 Ceng214) Sls - Ceng214

DBS-14.5: BUSES number(11) BUS NO BUS_NAME varchar2(20) t TYPE SCHEDULE varchar2(20)t varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t number(11) number(11) SCHEDULE_ID TRAVEL DATE SOURCE TOTAL_SEATS number(11) AVAIL_SEATS number(11) BUS NO O BUS_NO DURATION PAYMENTS DISCOUNTS PAYMENT_ID varchar2(3)t P TICKET ID varchar2(3) DISCOUNT_ID TICKET ID varchar2(3) number(11) O DISCOUNT_ID varchar2(3) DISCOUNT_AMOUNT number(11) O BD_ID TICKETS DISCOUNT ID varchar2(3) OSCHEDULE ID varchar2(3) number(11) number(11)O number(11) TICKET ID HEDULE ID FARE USER ID OUSER ID NO SEATS USERS PUSER ID number(11) varchar2(20) e ADDRESS varchar2(100) t number(11) EMAILID varchar2(30) e P primary key - not null e formign key NAME PHNO # data type - zurber a| data type - date It| data type - varchar2 CANCELLATION CANCELLATION_ID varchar2(3) varchar2(3) number(11)o TICKET ID BOOKINGDETAILS TICKET ID O BD ID ED ID BD ID number(11) ACC_NO number(11) NAME varchar2(10)t PUSER ID number(11) USER_ID…

TABLE 4-6 Parking Tickets at Millennium College Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 1. Convert to INF Relation 2. Draw dependency diagram showing all functional dependencies 3. Identify anomalies 4. Convert to 3NF Relations 5. Develop EER Diagram with appropriate cardinalities

Internet keyword searches are different from database keyword searches. The two are quite different from one another. What are the primary similarities and differences between the two in terms of the way queries are phrased and the information that is returned, and what are the advantages of each?

Program language: Python Prompt: Create histograms for each feature in a similar way for each of the different classes present in the data. Data: http://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data

Sub quiz6_1() For i = 4 To -1 Step -3 For J = -1 To 1 soln = i * J Next J Next i Cells(2, 2) = soln Cells(3, 2) = i * J %3D End Sub For the following section of code, determine what will be written into the spreadsheet in cell B3=

BASE SAS PROGRAMMING Question 12:- When a SAS data set is created from a spreadsheet, the spreadsheet column headings are always stored as which of the following?  a)  variable names                          b)  labels                          c)  formats                          d)  descriptor                          Question 13:- In SAS, one can test single or joint hypothesis after successful completion of  a)  Data portion                           b)  First observation                          c)  Descriptor portion                          d)  PDV                           Question 14:- The following SAS program is submitted: data work.products; Product_Number = 5461; Item = `1001`; Item_Reference = Item`/`Product_Number; run; Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?  a)  1111/1502                          b)  1001/ 5461                          c)  (missing numeric value)                          d)  The value can not be…

Set up Order [ single order ) Assign seats [ subscription ) Assign chairs Award bonus Debit Account charge credit card Mail packet

pls quickly answer

Q1:  STONEHENGE ENGINEERING WORKS: Stonehenge Engineering Works is a small company that specializes in complex engineering consulting projects.  Most Engineering projects need large data transaction. The company is moving into new offices and ask you to design their data communication network.  They are going to have two divisions in two different office sites in the same building, (two story office building) Engineering division in the first floor : They have a staff of 10 engineers (which is expected to grow  over the next five years. And, additional new 15 PCs will be needed ) and the Database for the product development.  Engineering division will be using 3D design and online collaborations tools which require large bandwidth and fast data communication. Management division in the second floor : There are 20 management and clerical employees who also need network connections, but whose needs are less intense. This site has database for the clients as well. All employees in the…

Q1:  STONEHENGE ENGINEERING WORKS: Stonehenge Engineering Works is a small company that specializes in complex engineering consulting projects.  Most Engineering projects need large data transaction. The company is moving into new offices and ask you to design their data communication network.  They are going to have two divisions in two different office sites in the same building, (two story office building) Engineering division in the first floor : They have a staff of 10 engineers (which is expected to grow  over the next five years. And, additional new 15 PCs will be needed ) and the Database for the product development.  Engineering division will be using 3D design and online collaborations tools which require large bandwidth and fast data communication. Management division in the second floor : There are 20 management and clerical employees who also need network connections, but whose needs are less intense. This site has database for the clients as well. All employees in the…

Mahmood AlI Ghasani University of Technology and Applied Sciences Ibri oard / Courses / AY_2020_2021 / Semester 2 / Information Technology / 54_ITDB101_DB_S2/ Final Examination nal Examination 13 April 2021 8:30 to 10:45 AM Course search There is a Hostel Booking Software in one of the hostels in Ibri. There you can book a suitable hostel room for yourself if you log in as a student. What type of user are you in this scenario? estion 3 st yet Swered larked out of O a. Application Programmer 00 Flag question Ob. Database Designer Oc. Database Administrator d. End User Previous page Next page TATMOLie ENG d

4G* VodaCom-SA A 100% O 9:38 SU6_I_DO_CH9 CMPG 122 User Interface Programming I_Do: Week 12 Chapter 9: Classes and Multiform Projects - Dorm and Meal Plan Calculator (Nr 6, Page 622) A university has the following dormitories: E Allen Hall E Pike Hall E Farthing Hall E University Suites $1,500 per semester $1,600 per semester $1,800 per semester $2,500 per semester The university also offers the following meal plans: o 7 meals per week A 14 meals per week A Unlimited meals $ 600 per semester $1,200 per semester $1,700 per semester Create an application with two forms. The main form should allow the user to select a dormitory and a meal plan. The application should show the total charges on the second form. See example below: E Program9_6 Meal Plan: Domitory: Allan Hall Pike Hall Farthing Hall University Suites 7 meals per week 14 meals per week Unlimited meals Domitory: $1,600.00 per semester Meal Plan: $600.00 per semester Total: $2,200.00 Display Form I Form 2

For Online learning CE VKC293AA VKC293AA SEC KOREA 728 SEC KOREA 728 U1 9-SYOO1913WX KM44C16100AS-6 SEC/KOREA 20 C3 MemoryMasters 128MB FPM NON PARITY SIMM SEC KOREA 728 R5 WARRANTY VOID IF REMOVED KM44C16100AS 6 VKC293AA KM44C16100AS-6 SEC KOREA 728 KM44C16100AS-6 SEC KOREA 728 Figure I RAM module - A Part A: refer to Figure 1, answer the following questions. 1. What is the type of RAM installed in the system? And What is the name of the manufacturer? 2. What is the capacity of the RAM? 3. How many pins does this RAM module have (count them)? What type is it, DIMM or SIMM? 4. What is the reason for the notch on the RAM module? ASSY IN U.S.A, R3 C1 R1DBD BR4 HU7 6

What is a User-defined data type (UDt)?