consider the victoria university information technology department, department has setup a small library for NIT5130 students. The department library maintains a checkout list ( CALL NO, USER ID, DATE REQUESTED) of all the books borrowed by students, Every student record consists of User ID, User name, Borrow limit, Number checked out, and fines. Suppose that the library will have multiple copies (CALL NO, AUTHOR NAME, PUBLISHER, ISBN, DATE PUBLISHED) can have multiple authors (AUTHOR NAME, DATE OF BIRTH, COUNTRY OF BIRTH, DECEASE BIRTH). You have volunteered to set up a database system for the library,
Draw an Entity relationship diagram for the IT department library
In: Computer Science
11. In the 5-Stage DuPont ROE formula, which of the following is considered a utilization ratio:
a. NI / EBT or the tax burden ratio
b. EBT / EBIT or the interest burden ratio
c. EBIT / Sales or the operating margin
d. Sales / TA or total asset turnover ratio
e. TA / SE or the leverage ratio
12. During lecture and on the lecture slides, we evaluated Vulcan Materials’ operating margin over a full 10 year business cycle. Because Vulcan Materials’ operating margin ________ when economic conditions deteriorate (e.g. during the housing crisis), Vulcan Material’s would best be categorized as a ________.
a. decreases ; cyclical company
b. increases ; cyclical company
c. decreases ; non-cyclical company
d. increases ; non-cyclical company
e. increases ; counter-cyclical company
13. You owe your credit company $25,000 and plan to make no payments on your credit card for 1.0 year. Due to your current credit score, your credit card company charges you an APR of 30.0%. If, however, you took measures to increase your credit score by 100points, your credit card company would instantaneously adjust your APR by 5.0%. How much would you save over 1.0 year if you took actions to increase your credit score?
a. $1,525
b. $1,603
c. $1,677
d. $8,622
e. $8,717
14. You are the beneficiary of a trust set up by your grandparents. You will receive a total of 60 after tax cash flows ($1,000 each) beginning six years from now (T=6) when you turn age 25. These payments are intended to help cover your living expenses over the course of your expected lifetime. Assume the appropriate discount rate is 6.0% per annum. What is the present value of the 60 payments?
a. $11,372
b. $11,393
c. $12,077
d. $12,098
e. $16,667
15. You have $1000 in a savings account today (T=0). Approximately how much longer would it take for your investment to double (i.e. to become worth $2000) if you earned 4.0% on your savings as opposed to 12.0% at the end of every calendar year? Hint: Think Rule of 72.
a. 6 years
b. 8 years
c. 12 years
d. 16 years
e. 18 years
In: Finance
Sing Mask is a local enterprise that manufactures surgical face masks that are sold locally as well as exported to the region. Due to a forecasted surge in demand for the next 3 years, Sing Mask decides to make its operations non-stop with a production line that runs 24 hours a day and everyday throughout the whole year, including public holidays.
Now is the last week of December and you are the Operations Manager overseeing manpower planning. Sing Mask’s Sales Director has provided the following monthly demand (each unit is equivalent to a box of 2000 pieces of face mask) for the next 3 years:
January: 800 units of demand
February: 600 units of demand
March: 800 units of demand
April: 1000 units of demand
May: 1200 units of demand
Jun: 1000 units of demand
July: 1100 units of demand
August: 900 units of demand
September: 800 units of demand
October: 1000 units of demand
November: 700 units of demand
December: 800 units of demand
Assume that demand is 800 units in January each year, demand is 600 units in February each year, etc. Further, demand must be met by the end of a month, e.g., the demand of 800 units must be met by the end of January, the demand of 600 units must be met by the end of February, etc.
Face mask production is relatively a low-technology type of operation and the main costs for the business are the storage cost and manpower cost.
Given its non-stop operation and the need to make manpower planning simpler, Sing Maskoffers its workers 1 month of paid leave for working 11 months consecutively (they will still be given rest days but they cannot take any annual leave). For example, a worker working in the month of January to November will enjoy 1 month paid leave in December. Assume that there are no fires or hires during the three years. Based on the historical data, a worker can produce up to 20 units of face mask in a month and is paid a salary of $1,800 per month.
Storage cost is incurred for any excess units produced that are above the monthly demand and estimated at $120 per unit of production. Any excess inventory at end of the year will be donated to local hospitals as part of Sing Mask’s corporate social responsibility thus there will not be any inventory at the end of December each year.
Question:
Determine an LP model to minimise Sing Maskannual cost (storage and manpower cost) while meeting all monthly demands. List any other assumption(s) you have made in your formulation.
Solve the Linear Program problem by using Microsoft Excel. Please provide answers with screenshots in Excel !!
In: Accounting
1. Use SQL to create a polyinstantiated table including a primary key and a unique constraint
2.Use SQL to insert multiple records for each security classification with the same ID. You must have 4 classifications.
3.Use SQL to create 4 schemas, one for each security classification 4.Use SQL to create a view in each schema that restricts the records to those belonging to a particular security classification and restricts the columns to only those columns that have relevant data.
5.Select from each of the views. Take a screen shot of the query results for each user(total of 4 for this step).
6.Use SQL to create 4 logins, one for eachsecurity classification
7.Use SQL to create 4 database users, one for each login with a default schema that matches the security classification for the login.
8.Use SQL to create 4 roles at the database level, one for each security classification.
9.Use SQL to assign each user to its specific role.
10.Use SQL to grant select on the appropriate view to the roles.
11.Execute tests as each of the four users, trying to select from their respective views. Take a screen shot of the query results for each user(total of 4 for this step).
12.Use SQL to revoke select on the view from the role
13.Use SQL to remove the users from the role
14.Use SQL to drop the users
15.Use SQL to drop the logins
16.Use SQL to drop the roles1
7.Use SQL to drop the views
18.Use SQL to drop the schemas
19.Use SQL to drop the table
In: Computer Science
Can you please type, I will rate you well! Thank you!
In this activity, you will be devising a Data Collection plan that describes how information on each asset will be collected.
Develop a Data Collection plan that can be used to perform Data Collection on the different assets in the Action Forensics organization. As you develop this plan you will have to make decisions based on your understanding of how the company works. Do not worry that you are making a wrong decision. For example, you may decide the owner of the 50 TB SAN is the network technician instead of the evidence custodian, or even one or more of the forensic investigators. What is important is that you document your reason for choosing one owner over another.
Based on your understanding of Action Forensics, identify what might be collected in the following areas:
For each item that you identify, decide which of the following specific items should be collected:
Decide which of the following specific items should be collected for an application:
Decide which of the following specific items should be collected for a database:
Remember, the object of this activity is to develop the Data Collection plan, not to actually collect the data. Keep in mind that someone who has never performed Data Collection should be able to follow your plan with a minimum of questions
In: Computer Science
|
Hide Folder Information |
|
| Turnitin® | |
| This assignment will be submitted to Turnitin®. | |
| Instructions | |
|
The Final Project for this course is the creation of an employee database. This assignment will give you some insight into how Visual Basic programming can be useful in the real world. As you work on this application, try to make it presentable like an application you would want to use if you were using an employee database application. Feel free to incorporate pictures to make it appeal to the user….be creative. Keep in mind the things you learned such as tab order and exception handling for user experience on the front end. Also, think about the coding you are doing and make sure you comment your code and follow Visual Basic standard conventions. What if a new developer were to make changes to the application? Will they understand your intentions and what the code is doing? Complete the following Programming Challenges: Programming Challenge #1 - Creating Employee Data found on page 625 of the textbook. Programming Challenge #2 - Reading Employee Data found on page 625-626 of the textbook. Programming Challenge #12 - Employee Data, Enhanced found on page 629 of the textbook. Specifically, be sure to meet the following criteria:
|
|
In: Computer Science
Questions of this part analyze the students’ understanding in analyzing the given scenario and practical skills to build Class diagrams studied in chapters 8, 10 and 12 of IT242.
The management of the groceries ordering system would desire to have a database system to keep track of orders, customers, drivers and stores. Read the following paragraph to answer the given questions.
The system maintains four users' information. For each user, the system keeps a unique ID, name, login, password, address, contact number, category (Grocery Owner, admin, customer and driver) and status (approved by admin or not). Each Grocery Owner has an address and name of the store. He can view one or more order also it can manage one or more product. Each order has an order ID, amount to pay, status and rate service. An order can be managed by one grocery owner and one admin. A single order is associated with one or more product. The product details to be stored are reference, quantity and price. A product can be processed by one grocery owner. Each driver can view and change the status of one or more order. An order can be assigned to one driver only. Each customer can make one or more order and fill zero or more complaints. Each complaint has a complaint ID, title, body and date. A complaint can be handled by one admin. Each admin can approve registration of store owners, drivers, and customers. He can view reports about the service ratings.
3.1 Draw a Class diagram for the given database. The diagram must show all classes, relationships between classes, and multiplicities.
Answer
In: Computer Science
Workshop: SQL Simple Retrieval For this workshop, you are to submit the SQL statements. Do not submit the output produced by running the query. However, you may wish to examine the output to ensure the correctness of the query. When writing a query, do not rely exclusively on the current content of the database. Remember that when working with a real-world company’s database there can be far too many rows to allow you to visually examine the content of a table and validate your query. The following exercises all pertain to the FACULTY table. This table has the following columns: FNO, FNAME, FADDR, FHIRE_DATE, FNUM_DEP, FSALARY, and FDEPT. The table is owned by the user STUDENT.
1. Display the entire FACULTY table.
2. Display all information about any employee whose yearly salary is less than $40000.
3. Display all information about any employee who is employed by the Computer and Information Systems (CIS) Department.
4. Display the department, faculty number, and name of all faculty members.
5. Display the name and date of hire for any faculty member whose department alphabetically precedes THEO.
6. Display the departments to which faculty are assigned. Do not show duplicate values.
7. Display the name and salary of any employee earning less than $36000. Present the result set such that the highest paid employee is listed first, the second highest is listed next, and so on - that is, show the result with salaries in descending sequence.
8. Display the department, employee name, and salary for every employee. The output should be presented such that rows are arranged by salary within department. (Employees assigned to the same department will appear next to each other, but these rows will be sorted by salary.)
In: Computer Science
1. Choose the false statement:
Group of answer choices
When eukaryotic organisms reproduce from one generation to the next, mutations play a far more important role as a source of genetic variation than does recombination.
One of the trends leading up to the evolution of early eukaryotic cells is a much-expanded genome and a shift from a haploid to a diploid amount of DNA.
The endosymbiotic theory supports the idea that mitochondria and chloroplasts were once free-living prokaryotic cells; this accounts for why these organelles contain DNA organized as a circular loop and ribosomes akin to those found in bacteria.
1b. Choose the false statement:
Group of answer choices
The structure shown demonstrates how the translation stage of gene expression can function as an assembly line to generate lots of protein product quickly.
Bacteria are able to regulate their metabolism by turning genes ON and OFF at the transcriptional level; this affects metabolism by determining the presence or absence of particular mRNAs in the cell.
As evidenced by our much much larger genomes, eukaryotes are much more complex than prokaryotes; a similar trend exists among different eukaryotes, such that the genomes of fruit flies or beetles are considerably smaller than that of more complex organism like humans.
1c. Choose the false statement:
Group of answer choices
The redundant nature of the genetic code implies that in some instances several different amino acids are coded for by the same codon.
Genes can be divided into two groups, those that code for proteins (e.g., structural genes) and regulators, those that control the expression of structural genes.
The karyotype shown belongs to a genetic male.
In: Biology
Robyn meets with Sonia to discuss her needs and interests. Robyn explains to Sonia that it would be really useful if she could get information on Sonia’s health from the health professionals she is seeing. Robyn explains that this information will be kept confidential, and that she will only ask for it with Sonia’s permission. Robyn listens to Sonia’s concerns respectfully, paraphrases them to ensure she has understood, and explains Sonia’s right to privacy.
Sonia tells Robyn that she has just spent four months in hospital. During that time she was made redundant from her job. Sonia is concerned that she will lose her home if she does not get another job soon. She is also worried that the stress will make her unwell again. Robyn realises that she will need to collaborate with other service providers to meet Sonia’s needs.
1.How has Robyn developed and maintained trust and goodwill with Sonia? (Approx. 35 words).
2.How did Robyn maintain Sonia’s confidentiality and privacy? (Approx. 10 words).
3. Give two examples of Sonia’s diverse and multifaceted needs in this situation. (Approx. 15 words).
4. What other service providers should Robyn collaborate with? (Approx. 10 words).
5. How could Robyn provide clear and current information to Sonia? (Approx. 50 words).
6.Give one example of Sonia’s interests and one example of her rights in this situation. (Approx. 25 words).
In: Nursing