Your answer to Section A should be about 250 words.

Please use APA style for all aspects of this Question. You must cite all course materials in-text; improper or missing citations will receive a zero grade and/or a formal investigation of academic misconduct. You are not allowed to use internet materials, quotations from outside readings or any “cut and paste” learning materials in any of your written answers. Write in your words only and draw on required course materials only

1. In the Introduction to the Course, we discussed three processes of globalization in the world economy: internationalization, liberalization, and the information and communications technological revolution(s). Explain the meaning of these terms, how they differ, and how they are important. Use specific empirical examples to clarify the abstract terms and illustrate the conceptual differences.

Develop a simple MIS (Management Information System) for High School Student that consists of a simple database (a text file). The system manages to dynamically input record/data into the database. The data from the database can be sorted, searched and updated. User also should be able to add new records/data, remove any data and etc.

• The system that will be developed must use a linked list structure.
• Use any sorting techniques to sort your data.
• Use any searching techniques to search for a data.
• Develop a user friendly and efficient system
• Use only notepad (a text file) as your simple database.
• must use C++ and text file only for the database.

Example of the user interface for a Students Management System.

Main Menu

Welcome to A* High School Students Management System.

Please select your choice:

1. Adding a new student record
2. Updating an existing student record
3. Search a student record.
4. View students record.
5. Remove a student record.
6. Exit.

Your choice: 4

Menu view students record

1. View a student record
2. View all students record

Your choice: 2

Guildline:

1. When updating the existing data, you should prompt a user to enter the ID. Once the ID is ready, you have to find the ID from your file/database. Retrieve data of the database. Then you can update the data such as the new address and phone number. Of course you cannot edit the ID, name and DOB.
2. When searching for a data, you should display the result. For example, if the data is found, the details of the data should be displayed.
3. Add function should able the new record being added into the existing database. For example, before this you have 4 records in your database, after adding a record, your file should have 5 data.
4. To view data of your record, the result should be sorted, just like the example given.

1. Examine the structures of the DEPARTMENT and ASSET tables:

   DEPARTMENT
   -------------------------
   DEPT_ID NUMBER(9) NOT NULL
   DEPT_ABBR VARCHAR2(4)
   DEPT_NAME VARCHAR2(25) NOT NULL
   MGR_ID NUMBER
   
   ASSET
   -----------
   ASSET_ID NUMBER(9) NOT NULL
   ASSET_VALUE FLOAT
   ASSET_DESCRIPTION VARCHAR2(25)
   DEPT_ID NUMBER(9)
   
   The DEPT_ID column of the ASSET table has a FOREIGN KEY constraint referencing the DEPARTMENT table. You attempt to update the ASSET table using 
   this statement:

   UPDATE asset

   SET dept_id =(SELECT dept_id
   FROM department
   WHERE dept_name =(SELECT dept_name
   FROM department
   WHERE dept_abbr = 'FINC')),
   asset_value = 10000
   WHERE asset_id = 2;
   
   Which two statements must be true for this UPDATE statement to execute without generating an error? (Choose two.)

   	A.	An asset with an ASSET_ID value of 2 must exist in the ASSET table.
   	B.	Only one row in the DEPARTMENT table can have a DEPT_ABBR value of FINC.
   	C.	One of the subqueries should be removed because subqueries cannot be nested.
   	D.	Both of the subqueries used in the UPDATE statement must return one and only one non-null value.
   	E.	Only one row in the DEPARTMENT table can have the same DEPT_NAME value as the department with DEPT_ABBR of FINC.

) Kragh states that quantum theory “owes is origin” to the problem of blackbody radiation. What was this problem? What were some other problems plaguing classical physics at the end of the 19^th Century?

(b) Briefly explain the history of attempts to solve the blackbody problem: Wien’s 1894 proof, Wien’s 1896 law, Planck’s 1899 derivation of Wien’s law, and Planck’s own radiation law (along with the “quantum hypothesis” made in Dec. of 1900).

(c) How well these laws fit the empirical data was of course part of the evaluation of their “truthiness”. But other (dare we say philosophical?) motivations drove Planck’s work in particular. Explain the non-empirical considerations that guided Planck’s thinking about blackbodies, eventually leading to the birth of QM.

explain in a detailed paragraph please  - What is meant by the genetic code being universal and redundant?

QUESTION 4

a) Malaysian United Bank has implemented an ERP system. One of the features of the ERP system is to allow a new customer who wants to open a new bank account to insert their MyKad to a card reader. The card reader will then extract the customer’s information from the MyKad microchip and automatically update this information to the computer database system. Assumed that Azman wishes to open a new savings account. At the customer service counter, Azman inserted his MyKad into the card reader and his information such as his name, IC number, address, DOB, and gender was automatically updated to the computer database system. However, the bank officer asked Azman to fill up this information again on the hardcopy application form with the thumbprint and signature. According to the bank officer, this is a standard operational procedure (SOP) for opening a new account. What is value analysis? Based on the idea of value analysis, discuss the above scenario from the perspectives of both the customer and the bank officer.

b) What is Software as a Service (SaaS)? What are the advantages of SaaS when implementing an ERP system in a mid-size company?

CITATIONS on 7PS

Please supply citations on problem 7PS

Subject is financial management

Question 6        (Marks: 35) Structured Query Language (SQL) is a language that is widely used in industry to create, update and query data in relational databases. This question must NOT be done practically (i.e. in the computer room). You are required to write the SQL code in your answer book. Q.6.1 The below sample data in third normal form was provided by a database designer. Answer the below questions using this data. Table: Country Primary key: CountryID (auto number) All fields are mandatory CountryID Name Abbreviation CallingCode 1 South Africa ZA 27 2 Lesotho LS 266 3 Namibia NA 264 4 Egypt EG 20 Table: President Primary key: PresidentID (auto number) Foreign key: CountryID (mandatory) All fields are mandatory PresidentID CountryID Name Surname Year 1 1 Cyril Ramaphosa 2018 2 1 Jacob Zuma 2009 3 3 Hage Geingob 2015 4 3 Hifikepunye Pohamba 2005 18; 19; 20                       2020 © The Independent Institute of Education (Pty) Ltd 2020   Page 10 of 11    Q.6.1.1 Write a SQL statement to create the table President. Hint: The sample data should give you an indication of the data types you should use. (5)      Q.6.1.2 Write a SQL statement that will count the number of presidents that were inaugurated after 2009. (4)      Q.6.1.3 Write a SQL statement to insert the below row into table Country. CountryID Name Abbreviation CallingCode 5 Botswana BW 267 (4)      Q.6.1.4 Write a SQL statement to get the list of all the countries from the database, in alphabetical order by country name. Include all the columns from the Country table. (3)      Q.6.1.5 Write a SQL statement to get the list of all the presidents with a surname starting with the letter R. Include all fields from the President table. (3)      Q.6.1.6 Write a SQL statement to get the list of all the presidents, showing only the name and surname of the president, and the name of their country. (5) Q.6.2 What is the difference between the WHERE and HAVING clauses in SQL statements? (4) Q.6.3 What is the purpose of an index in a SQL database? (1) Q.6.4. The below ERD has been implemented in a SQL database. What will the result be of each of the below queries? Provide an explanation for your answer.   18; 19; 20                       2020 © The Independent Institute of Education (Pty) Ltd 2020   Page 11 of 11 Q.6.4.1 (2)      Q.6.4.2 (2)      Q.6.4.3  

1. The functional dependencies for the ProAudio relation:

c_id -> f_name, l_name, address, city, state, zip

item_id -> title, price

ord_no -> c_id, order_date

ord_no  + item_id  -> shipped

zip -> city, state

Original ProAudio relation:

determining functional dependencies for ProAudio database

Normalization is a set of rules that ensures the proper design of a database. In theory, the higher the normal form, the stronger the design of the database.

Use the file for Functional Dependencies Above to answer the following questions:

Now that you are familiar with the mission statement and the entities and attributes the for ProAudio:

1. Identify anomalies in ProAudio- Give 3 examples means that you list specific instances from ProAudio on insert, delete or update anomalies, describing each in the context of the ProAudio database.

1. • ProAudio Anomaly example 1
   • ProAudio Anomaly example 2
   • ProAudio Anomaly example 3
2. Resolve ProAudio anomalies- citing the anomalies you described in the previous section- specifically say how to fix each one
3. • Fix 1
   • Fix 2
   • Fix 3

- List 10 policies for windows client update and server update