Database Systems - Security and Administration

Jak University is a leading higher education institution that is well known throughout Malaysia for its academic achievements. It is proven that this university exists in all major cities in Malaysia. Jak University is also in Kuala Lumpur and as a management center, has 100 thousand students and 10 thousand lecturers spread across several branch campuses. The learning process is done face-to-face and online. Each campus in each city can join virtual classes, so that the data from each campus can be connected to one another. Academic data from each campus branch is stored in files and then sent to the Center in Kuala Lumpur and each campus can also share data (share files). However, after this university has been operating for several years, the number of lecture transactions has increased, so that the volume of data stored in files is getting bigger. So in day-to-day operations often experience problems access to data, both when sending data and when accessing data from other campuses.

Question:

1. The University of Jak uses a file-based approach in managing its academic data. But over time began to experience problems with data accessibility.
You were appointed as a Database Consultant to change the data management process at the University of Jak using a database approach. You need to explain to the Management in Kuala Lumpur so that the leaders can understand and be sure about the proposed application of the database approach, where this approach can support operational performance in data management. Explain what is meant by a file-base approach and a database approach. Also describe the advantages and disadvantages of each.

2. If the management approves the proposal, then you need to design a good database architecture. You can choose a Three-Tier Client-Server architecture.

3. The hardware running the DBMS must continue to operate even if one of the hardware components is damaged due to various factors. One solution is to implement RAID technology. Describe what RAID technology is. Also explain by providing examples of how each RAID level is implemented.

Chapter 9: The discussion topic for this week is very interesting, as it is likely that everyone at least knows someone who has some type of genetic disorder or has heard about a disorder that they wanted to understand more fully. You should look into a specific disorder and provide more information about it from any angle you like. Please be sure to include some information that pertains to the chapter (like the inheritance pattern--that is, whether it is autosomal dominant or recessive or sex-linked or whatever). ***I absolutely need in text citations and the ending reference citations...*****

You should look into a specific disorder and provide more information about it from any angle you like.

Please be sure to include some information that pertains to the chapter (like the inheritance pattern---this is the question

Chapter 9: The discussion topic for this week is very interesting, as it is likely that everyone at least knows someone who has some type of genetic disorder or has heard about a disorder that they wanted to understand more fully. You should look into a specific disorder and provide more information about it from any angle you like.

Please be sure to include some information that pertains to the chapter (like the inheritance pattern--that is, whether it is autosomal dominant or recessive or sex-linked or whatever).

You should look into a specific disorder and provide more information about it from any angle you like.

Please be sure to include some information that pertains to the chapter (like the inheritance pattern...this is what you need to talk about...

***I absolutely need in text citations and the ending reference citations...*****

Course: Information technology in a global economy

This discussion topic is to be reflective and will be using your own words and not a compilation of direct citations from other papers or sources. You can use citations in your posts, but this discussion exercise should be about what you have learned through your viewpoint and not a re-hash of any particular article, topic, or the book.

Items to include in the initial thread:

• “Interesting Assignments” - What were some of the more interesting assignments to you?
• “Interesting Readings” - What reading or readings did you find the most interesting and why? “Interesting Readings”
• “Perspective” - How has this course changed your perspective?
• “Course Feedback” - What topics or activities would you add to the course, or should we focus on some areas more than others?

sum1Q1: What research methods might you use to update your knowledge of professional and legislative requirements relating to accounting activity statements? (300–400 words)

Company A and Company B are both wholly owned subsidiaries of Parent, Inc. Parent has no other operations, balance sheet items or income statement items other than its ownership of Company 1 (located in China) and Company 2 (located in US). Company 2 periodically sells goods to Company 1 for resale to end customers. Such goods are sold at the same pricing terms that Company 2 sells to all other customers. Prior to January 1, 2018, there had never been any inventory sales from Company 1 to Company 2 or from Company 2 to Company 1. The following is data for each company for 2018 and 2019:

Company 1 Company 2

     Year ended 12/31/18

Sales to all customers $300 million $150 million

Costs of sales $150 million $100 million

All other non production expenses $ 60 million $ 40 million

Pre tax income $ 90 million $ 10 million

Inventory purchased from Company 1 held

By Company 2 at end of year NONE

Inventory purchased from Company 2 held

By Company 1 at end of year $15 million

    Year ended 12/31/19

Sales to all customers $280 million $160 million

Costs of sales $140 million $120 million

All other non production expenses $ 60 million $ 30 million

Pretax income $ 80 million $ 10 million

Inventory purchased from Company 1 held

By Company 2 at end of year NONE

Inventory purchased from Company 2 held

By Company 1 at end of year $16 million

What would consolidated pretax income be for Parent for 2018 and 2019

Company A and Company B are both wholly owned subsidiaries of Parent, Inc. Parent has no other operations, balance sheet items or income statement items other than its ownership of Company 1 (located in China) and Company 2 (located in US). Company 2 periodically sells goods to Company 1 for resale to end customers. Such goods are sold at the same pricing terms that Company 2 sells to all other customers. Prior to January 1, 2018, there had never been any inventory sales from Company 1 to Company 2 or from Company 2 to Company 1. The following is data for each company for 2018 and 2019:

Company 1 Company 2

     Year ended 12/31/18

Sales to all customers $300 million $150 million

Costs of sales $150 million $100 million

All other non production expenses $ 60 million $ 40 million

Pre tax income $ 90 million $ 10 million

Inventory purchased from Company 1 held

By Company 2 at end of year NONE

Inventory purchased from Company 2 held

By Company 1 at end of year $15 million

    Year ended 12/31/19

Sales to all customers $280 million $160 million

Costs of sales $140 million $120 million

All other non production expenses $ 60 million $ 30 million

Pretax income $ 80 million $ 10 million

Inventory purchased from Company 1 held

By Company 2 at end of year NONE

Inventory purchased from Company 2 held

By Company 1 at end of year $16 million

What would consolidated pretax income be for Parent for 2018 and 2019

A study conducted several years ago reported that 24 percent of public accountants changed companies within 4 years. The American Institute of CPAs would like to update the study. They would like to estimate the population proportion of public accountants who changed companies within 4 years with a margin of error of 4% and a 95% level of confidence. (Round your z value to 3 decimals. Round up your answers to the next whole number.)

a. To update this study, the files of how many public accountants should be studied?

b. How many public accountants should be contacted if no previous estimates of the population proportion are available?

Q1- Discuss the difference between batch and online processing. For the below scenarios identify which data processing method would be appropriate and why?

Q2- Identify which of the following actions will update a master file and which one will be recorded in a transaction file?

a. Record daily sales

b. Record sales commissions

c. Change customer credit limit

d. Update accounts payable balance

e. Record purchases

The distribution of durations for which apartments remain empty after the resident moves out for one property management company over the past 10 years was approximatley normal with mean of 95 days and a standard deviation of 29 days. The property management company intends to update the kitchen appliances in the apartments that were empty for top 10% of durations. What is the minimum duration for which an apartment remained empty for the company to update the kitchen appliances? Round to the nearest whole number.
Choose 1 answer:
A) 48 days
B) 112 days
C) 114 days
D) 123 days
E) 129 days