1. Describe and discuss the main elements of the Entity-Relationship (E-R) model. Include an example.
2. Briefly describe the process of converting an extended E-R model into a relational database design.
3. How are one-to-many recursive relationships addressed using the relational model?
4. Explain the representation of a one-to-many strong entity relationship in a relational database design.

Write these considerations in the form of a database design security checklist that includes your top six to eight security implications for the database design. A security assessment checklist is a common practice in the industry and proves to a CIO or IT auditor that you are following best practices in securing a database. It also serves as a living document to assist you in your design process. For example, on the networking side of IT, Cisco provides this checklist: https://www.cisco.com/c/en/us/solutions/small-business/resource-center/secure-my-business/network-security-checklist.html for small and medium business to evaluate their network infrastructure. You will use the information from this website to assist you in creating your own checklist.

When creating the Academic Database, there were several instances of data validation. Data types were assigned to each field in the table to stop undesirable values from being placed into certain fields. A presence check was used on fields that were listed as NOT NULL, requiring some data to be input. Uniqueness validation was automatically assigned for fields that were primary keys. Describe at least one field in the Academic Database a table where range validation could have been used and describe at least one field in the Academic Database where choice validation could have been used. Your answer should be addressed in 100 to 150 words.

Question 3 (Total 6 marks)

Biogen Pharmaceutical Ltd is a large pharmaceutical company based in Australia. During the year ending 30 June 2020, Biogen Pharmaceutical Ltd purchased two electronic databases containing scientific data related to respiratory drugs. Database A was acquired for $1,000,000 and contains data that is copyright protected. Database B was acquired for $800,000 and contains data that is not copyright protected. Required

(a) Explain whether Database A and Database B satisfy:

(i) The definition of an intangible asset in accordance with AASB 138 Intangible Assets, and

(ii) The recognition criteria for an intangible asset in accordance with AASB 138 Intangible Assets.

(b) If both databases were recognised by Biogen Pharmaceutical Ltd as intangible assets, explain:

(i) How the databases would be measured on initial recognition and subsequent to initial recognition, and

(ii) Whether the useful life of the databases would be assessed as finite or indefinite.

important: The relevant requirements of AASB 138 Intangible Assets have been appropriately applied and particularly explained.

.

Exercise 1 Questions

Answer Exercise 1 questions on a separate word document.

1. Terminology: For each description below, give the appropriate term to match the description (Hint: Remember terms are bolded in the text).
   1. There is a table that lists the different stores a retail location operations and different attributes about each store is contained in a column of the table. One of these attributes is location and another lists the date the store was first opened.
   2. Employees are listed in a payroll database. There is a field that contains numbers that the employees are given upon hire, and no two employees have the same number.
   3. Someone writes code that will search the database to tell their boss how many deliveries they have made to Hawaii in the past month.
   4. In a hospital database, there is a patient table, and every line in the table contains information from a patient.
   5. A firm has a policy that only gives permission to alter or change data already stored in the database.
   6. A field in a table listing delivery addresses has numbers that uniquely identify which customer is attached to the delivery.

We plan to develop customer’s database that stores customer’s number (ID), first name, last name and balance. The program will support three operations: (a) reading and loading customer’s info from the text file, (b) entering new customer’s info, (c) looking up existing customer’s info using customer’s number(ID), (d) deleting the customer’s info and (e) the updated database will be stored in the text file after the program terminate.

Customer’s database is an example of a menu-driven program. When the program begins to execute, it first read the text file and upload customer’s info. Then it presents the user with a list of commands. The user can enter as many commands as desired, in any order. The a command prompts the user to enter customer’s number (ID), first name, last name and balance, which are then stored in the program’s database. The f command prompts the user to enter a customer number and then display the corresponding record on the screen. The q command saves the information in the database to the file specified by the user and terminate program.

Based on the project description, please design classes and their corresponding methods. You need describe each method and write API for each method (Leave method body blank) (Hint: you need design one driver class, one database class and one customer record class). Based on your design, please draw the UML diagram as well.

database.txt

12345 Sebastian vanDelden 123.22
11111 Sarah Smith 45.89
22222 Sue Johnson 7765.98
33333 Billy Hunts 374.99

Based on your design/code, please draw a simple but detailed UML diagram as well? (This is the question that needs to be answered!) the code isn't needed for this.

When would researchers want to investigate an empirical distribution and when would researchers want to apply a normal distribution?

Political Economy Question:

Describe the empirical trends of wages, profits since 2009 up to and including the Trump administration.

What are the short-term and the long-term behavior patterns of stock prices as shown in empirical studies? Discuss briefly