COIT 20247: ERD Assignment 1

(call 7207666160 for Solution)

Due date:                            Fridayof Week 5(April 6, 2018- 11:45 pm AEST)     

Weighting:                         30%

Length:                                N/A

Objectives

·         To develop a conceptual data model diagram

·         To perform logical design (optional)

Assignment Specification

In this assignment, youneed to perform the followingtasks for the given case study:

·         Draw an Entity Relationship (ER) diagram

·         Perform logical design(optional)

·         Create3NF Relations(optional)

Case Study

CQ Insurance (CQI) offers insurance policies to insure Home-buildings and Home-Contentsof Australianresidents.  For each of their properties (Homes) of interest, the customers can apply for either a Home-buildings policy or a Home-contents policy or a combined Home-buildings-contents policy.  CQI allows a customer to have only one of the above mentioned policies for each of his/her properties.

When new customersapproach for an insurance policy (hereafter called as policy), CQI collects their details so that they can communicatewith them in future. Each policy requires full premium payment prior to the coverage period of one year.  At the time of preparing the policies, CQI collects the details of the property (Home) and/or items (Home contents) depending upon the type of the policy that the customer is interestedin.

At the time when a customer lodgesan insurance claim (hereafter called as claim) such as collapse of false ceiling, loss of home contents, etc., CQI ensures that the insurance policy has not lapsedprior to processing the claimsand further verifies that the items claimed have been covered by the respective policy.A claim should be related to only one policy but each claim is not limited to only one item that has been covered by the policy.As part of the claim-processing for each of the claims, an assessor (appointed by CQI) prepares and submits an initial assessment and if required the assessor also prepares and submits afinal assessment.  The assessor’s initial assessment may recommend either to further process or reject the related claim. The assessor’s final assessment will provide the total amount that can be settled relating to the claim and may contain a memo that describes the recommended settlement amount for each of the items that have been claimed.

Note:

The attributes of the possible entities have not been mentioned clearly.  Hence, you need to assume at least two and at most nine relevant attributes for each of the entities that you will identify for your ER diagram.

In addition to the recommendations in the assessor’s report, the following processes can also provide the reasons for rejection of the claim:

·         Verification to ascertain whether the claimed items have been covered by the respective policy or not

·         Ensuring that the policy is in force (has not lapsed) at the time of lodging the claim

Assignment Requirements

In this assignment,you need to create an Entity Relationship (ER) diagram relevant to the above case study and optionallyperform logical design to produce appropriate3NF Relations.

The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.

1       Draw an appropriate ER diagram

Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study. 

Your ERDmust

•             show all necessary entities, attributes andrelationships

•             show identifiers/identifying attributes as necessary

•             show multi-valued attributes, ifany

•             show participation andcardinality

•             show associative entities, ifappropriate

•             show weak entities, if any

•             use the notation described in the settext

•             use consistent and appropriate naming for entities and attributes  as specified in the unit text book

Somebusinessrulesorotheraspectsofthecasestudymaynotbecleartoyouwhenyoureadthecase study.Ifthisisthecase,thenyoushouldeitherapproachyourlecturerortutorforclarification,oryou maysimplymakeanassumptionandthendevelopyourERD accordingly.Forexample,thecase study might not mention all relevant participation information (also called minimum cardinalities). Ifso, you may make an assumption about what the minimum cardinalities might reasonably be, and thenshow theminyourERDaccordingly.Youshouldjustifyeachassumptionintermsofthebusiness,for example:itisassumedthateachcustomermusthaveatleastonepolicybecauseitisassumedthatthe business does not record customer details until the customer opts for a policy with them.Togetyourselfstarted,askyourself,'IfIwererunningthisbusiness,whatthingsIneedtokeepa list of?'  Write those things down.  For each thing, what information would you need to record aboutit? How can it be identified? The answers to these questions will help you to develop your ERD.

2       Assumptions and Business rules

Provide assumptions and business rules relevant to your ERD.

3       Create Logical Design (Optional):

If you would like to perform this optional component of this assignment, you can map your Entity Relationship diagram (ERD) into relations and make sure that all the relations are in 3NF.  Provide all the relationsin the following format:

Customer (CustomerId,customerName,Street,Suburb,State,PostCode,Email)

Invoice (InvoiceNumber,invoiceDate, Total, CustomerId)

foreignkey(CustomerId)referencesCustomer(CustomerId)

Howandwhattosubmit:

You must make an electronic submission for this assignment using the appropriate assignment submission link in the unit web site. 

You should submit a Microsoft Word documentcontaining:

•                     A copy of your ERD.

•                     A list of business rules and assumptions including theirjustifications.

•                      3NF Relations – optional

Yourdocumentshouldcontainappropriateidentifyinginformation(yourstudentnumber,name,unit number, etc.) and should contain appropriate headings for eachsection.

Important points

•                     You must work individually on thisassignment.

•                     ThemodelsolutiontothisassignmentwillbereleasedapproximatelyTWO(2)weeksafterthe due date.

•                     Assignments that are submitted after the release of the model solution will receivezero marks.

•                     Youmuststateinyourassignment(attheendundertheheadingAcknowledgementsisagood place) all materials and sources you used. This may be as simple as 'This assignmentwas completed using only the COIT20247unit materials' to mention that you have used only the items provided by the unit COIT20247.

•                     Beforesubmittingyourassignment,reviewthemarkingcriteriathat are available in the assignment specification.Ensurethatallthecriteriaareaddressedin your submission.

•                     After submitting your assignment, please verify that your submission was successful,i.e. download your submitted files to ensure that they are correct.

•                     Penalty related to late submission and plagiarism is handled as per the university policies.

Marking Criteria:

	Item	Maximum Marks
1	Identified entities (including super type and sub type entities), associative entities, weak entities (if any) and named appropriately	6
2	Provided appropriate attributes	6
3	Provided identifiers/identifying attributes	3
4	Drawn correct relationships between entities and named them appropriately	5
5	Used proper symbols for ·         entitiesincluding super type and sub type; associative entities; weak entities if any ·         relationships ·         identifying attributes ·         min and max cardinalities for the relationships	6
6	Provided appropriate justification for assumptions and business rules	4
	Penalty due to plagiarism/copying
	Late Penalty: Less 5% of available marks per calendar day
	Total	30

Task

Total marks: 30

Answer the following Questions

Question 1

a) Determine the value of base x if (152) x = (6A) 16 Please show all steps. [5 marks]

b) Convert the followings: (Please show all steps) [1.5x4=6 marks]

i) 0xBED into 3-base representation

ii) 321 7 into 2-base (binary) representation

iii) 1235 into octal representation

iv) 21.21 8 into decimal representation

c) Given a (very) tiny computer that has a word size of 3 bits, what are the lowest value (negative

number) and the highest value (positive number) that this computer can represent in each of the

following representations? [2X3= 6 marks]

i) One's complement

ii) Two's complement

iii) Signed Magnitude

Question 2.

a)      Are these two combinational circuits equivalent? Provide proof of your claim. [4 marks]

b) Consider the following logic diagram of a combinational circuit where A and B are inputs and X is

the output. Two 2-input AND gates, one 2-input OR gate, and two inverters are used in the circuit. It is

possible to reduce some of the logic gates without changing the functionality of the circuit. Such

component reduction results in higher operating speed (less delay time from input signal transition to

output signal transition), less power consumption, less cost, and greater reliability. Construct a logic

diagram of a circuit which does have the same function output. Please show the steps. [4 marks]

c) Using basic Boolean algebra identities for Boolean variables x, y, and z, prove that

Please show all steps and mention the identities used. [5 marks]

CIS5100 Quiz 1 Questions and Answers

Contact 8885066160 for Australia Assignment help

Question 1

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the below is not a characteristic of Web 2.0?

Select one:

a. Web browser

b. Collaboration system

c. Explicit knowledge

d. Knowledge management

Question 2

Answer saved

Marked out of 1.00

Flag question

Question text

All of the following are forms of e-business except _____________.

Select one:

a. Subscription fee

b. Infomediaries

c. Online marketplace

d. Content provider

Question 3

Answer saved

Marked out of 1.00

Flag question

Question text

Many websites, blogs and podcasts use _______ to constantly feed news to consumers instead of having the consumer search for the news.

Select one:

a. Source code

b. Mashup

c. RSS

d. SNA

Question 4

Answer saved

Marked out of 1.00

Flag question

Question text

________ is a standard electronic process for B2B market purchase payments.

Select one:

a. Financial GIS

b. Financial EFI

c. Financial EDI

d. Financial GPR

Question 5

Answer saved

Marked out of 1.00

Flag question

Question text

What is the ability of an organisation to tailor its products or services to the customers' specifications?

Select one:

a. Mass customisation

b. Long tail

c. Personalisation

d. Information reach

Question 6

Answer saved

Marked out of 1.00

Flag question

Question text

A system is a collection of parts that link together to __________.

Select one:

a. Achieve a common purpose

b. Gather experience

c. Implement solutions

d. Monitor the company

Question 7

Answer saved

Marked out of 1.00

Flag question

Question text

What is the type of knowledge that consists of anything that can be documented, archived and codified, often with the help of IT?

Select one:

a. Virtual knowledge

b. Explicit knowledge

c. Pure knowledge

d. Tacit knowledge

Question 8

Answer saved

Marked out of 1.00

Flag question

Question text

What are the two categories that include intellectual and knowledge-based assets?

Select one:

a. Efficient knowledge; tacit knowledge

b. Open knowledge; closed knowledge

c. Explicit knowledge; tacit knowledge

d. Intelligent knowledge; explicit knowledge

Question 9

Answer saved

Marked out of 1.00

Flag question

Question text

What is web content that is created and updated by many users for many users?

Select one:

a. Cybermediation-contributed content

b. Executive-generated content

c. Customer-contributed content

d. User-generated content

Question 10

Answer saved

Marked out of 1.00

Flag question

Question text

________ is a security protocol that protects Wi-Fi networks.

Select one:

a. Wireless security regulations

b. Wi-Fi protected access

c. Wi-Fi technology port

d. Wireless prevention policy

Question 11

Answer saved

Marked out of 1.00

Flag question

Question text

Updating business strategies is a continuous undertaking as internal and external environments _______.

Select one:

a. Become less competitive

b. Rapidly change

c. Remain stagnant

d. Become more consistent

Question 12

Answer saved

Marked out of 1.00

Flag question

Question text

Lisa loves her job as an executive recruiter for a large hospital located in Melbourne. Part of Lisa's job requires her to gather industry information, collaborate with partners, compare competitors and tap into the knowledge of prospective employees, partners and customers. Which of the below would Lisa use to perform her job?

Select one:

a. Network effect

b. Source code

c. Interactivity metrics

d. Collective intelligence

Question 13

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following represents the primary e-business revenue models?

Select one:

a. B2B, B2C, C2C, C2B

b. Content providers, infomediaries, online marketplaces, portals, service providers, transaction brokers

c. Advertising fees, licence fees, subscription fees, transaction fees, value-added services fees

d. Blogs, wikis, instant messaging, real simple syndication, podcasting, web conferencing and search engine optimisation

Question 14

Answer saved

Marked out of 1.00

Flag question

Question text

Michael Porter defined the Five Forces Model and the potential pressures that can hurt sales. Which of the following is not one of the potential pressures that can hurt sales?

Select one:

a. Substitute products can steal customers.

b. Competition can steal customers.

c. Suppliers can drive down profits by charging more for supplies.

d. Greater sales automation can decrease time taken to fulfil sales orders.

Question 15

Answer saved

Marked out of 1.00

Flag question

Question text

Sony started as a tiny company that built portable, battery-powered transistor radio. The sound quality was poor, but customers were willing to overlook that for convenience and portability. With the experience and revenue stream from these portable radios, Sony improved its technology to produce cheap, low-end transistor amplifiers that were suitable for home use, and invested those revenues in improving the technology further, which produced still better radios. This is an example of:

Select one:

a. Digital Darwinism.

b. Web 3.0.

c. Sustaining technologies.

d. Disruptive technologies.

Question 16

Answer saved

Marked out of 1.00

Flag question

Question text

Amazon.com uses a customer profiling system whenever a customer visits its website. Using this system, Amazon can offer products tailored to that particular customer's profile and buying pattern. What is Amazon using to achieve this competitive advantage?

Select one:

a. Substitute product.

b. Buyer power.

c. Product differentiation.

d. Rivalry.

Question 17

Answer saved

Marked out of 1.00

Flag question

Question text

When reviewing Porter's value chain analysis, which of the below provides customer support after the sale of goods and services?

Select one:

a. Service.

b. Operations.

c. Outbound logistics.

d. Inbound logistics.

Question 18

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is not a typical way that a company would duplicate a competitive advantage?

Select one:

a. Carrying large product inventories.

b. Copying the business operations.

c. Hiring away key employees.

d. Acquiring the new technology.

Question 19

Answer saved

Marked out of 1.00

Flag question

Question text

Amazon creates a unique recommendation listing for each customer that revisits its website. How would you classify Amazon's e-business strategy?

Select one:

a. Personalisation

b. Interactivity

c. Information richness

d. Mass customisation

Question 20

Answer saved

Marked out of 1.00

Flag question

Question text

Shawn McGill is on the executive board for ABC pharmaceuticals. The company produces the number one selling cancer fighting drug on the market. Due to its incredible success ABC pharmaceuticals has decided to increase the cost of the drug from $8 a pill to $15 a pill. Which force is ABC pharmaceutical using to increase its drug price?

Select one:

a. Business power.

b. Buyer power.

c. Threat of false entrants.

d. Supplier power.

Question 1

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following statements is true?

Select one:

a. IT represents business success and innovation.

b. IT equals business success.

c. IT equals business innovation.

d. IT enables business success and innovation.

Question 2

Answer saved

Marked out of 1.00

Flag question

Question text

Jennifer Bloom is writing a paper and she must determine which of Porter's three generic strategies The Museum Company has implementeD. Jennifer finds out that The Museum Company offers specialty products found only in museums around the world to affluent customers. What would Jennifer determine The Museum Company is using as its generic strategy?

Select one:

a. Narrow market, high cost.

b. Narrow market, low cost.

c. Broad market, high cost.

d. Broad market, low cost.

Question 3

Answer saved

Marked out of 1.00

Flag question

Question text

________ is a standard electronic process for B2B market purchase payments.

Select one:

a. Financial EFI

b. Financial EDI

c. Financial GIS

d. Financial GPR

Question 4

Answer saved

Marked out of 1.00

Flag question

Question text

Amazon.com uses a customer profiling system whenever a customer visits its website. Using this system, Amazon can offer products tailored to that particular customer's profile and buying pattern. What is Amazon using to achieve this competitive advantage?

Select one:

a. Rivalry.

b. Buyer power.

c. Substitute product.

d. Product differentiation.

Question 5

Answer saved

Marked out of 1.00

Flag question

Question text

Tinyme.com.au offers people the opportunity to visit its website and order baby products in special colours and/or custom names. How would you classify Tinyme’se-business strategy? 

Select one:

a. Information richness

b. Personalisation

c. Interactivity

d. Mass customisation

Question 6

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is not a topic or feature that is included in Web 3.0?

Select one:

a. A worldwide database

b. Intelligent applications

c. Integration of legacy devices

d. Social networking

Question 7

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the below is not a characteristic of Web 2.0?

Select one:

a. Technical skills are required

b. Eliminates entry barriers to publishing on the Web

c. Provides an exciting and vibrant virtual environment

d. Encourages user participation

Question 8

Answer saved

Marked out of 1.00

Flag question

Question text

What is a competitive advantage?

Select one:

a. A feature of a product or service on which customers place a lesser value than they do on similar offerings from a supplier.

b. A product that an organisation's customers place a lesser value on than similar offerings from a competitor.

c. A service that an organisation's customers place a lesser value on than similar offerings from a supplier.

d. A feature of a product or service on which customers place a greater value than they do on similar offerings from competitors.

Question 9

Answer saved

Marked out of 1.00

Flag question

Question text

Network operators believe that they are like _____________ and they cannot be expected to police what users say.

Select one:

a. transporters

b. servants

c. the post office

d. pipelines

Question 10

Answer saved

Marked out of 1.00

Flag question

Question text

What is software whose source code is available free for any third party to review and modify?

Select one:

a. Network source

b. Code source

c. Open source

d. Free source

Question 11

Answer saved

Marked out of 1.00

Flag question

Question text

Cheryl Steffan is the operations manager for Nature's Bread Company, which specialises in providing natural products for health conscious individuals. Cheryl is responsible for compiling, analysing and evaluating daily sales numbers to determine the company's profitability and forecast production for the next day. Which of the following is an example of knowledge that Cheryl would be using to successfully perform her job?

Select one:

a. Best-selling product by day.

b. Compare the costs of supplies including energy over the last five years to determine the best-selling product by month.

c. Craig Newmark is customer number 15467.

d. Best-selling product changes when Tony the best baker is working.

Question 12

Answer saved

Marked out of 1.00

Flag question

Question text

What is a major challenge of operating a network in a connected world?

Select one:

a. Telecommuting demands

b. Security issues

c. Society demands

d. Personal issues

Question 13

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is not considered a category within the primary value activities in a value chain analysis?

Select one:

a. Inbound logistics.

b. Firm infrastructure.

c. Operations.

d. Service.

Question 14

Answer saved

Marked out of 1.00

Flag question

Question text

________ is a security protocol that protects Wi-Fi networks.

Select one:

a. Wireless security regulations

b. Wireless prevention policy

c. Wi-Fi technology port

d. Wi-Fi protected access

Question 15

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following represents the definition of a variable?

Select one:

a. A data characteristic that is collected through competitive intelligence and cannot change over time.

b. A data characteristic that is collected only through competitive intelligence and can change over time.

c. A data characteristic that stands for a value that does not change or vary over time.

d. A data characteristic that stands for a value that changes or varies over time.

Question 16

Answer saved

Marked out of 1.00

Flag question

Question text

When evaluating the business value of disintermediation the more ____________ that are cut from the distribution chain, the lower the product price.

Select one:

a. Customers

b. Intermediaries

c. Technology

d. Data stream

Question 17

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the statements below is not accurate in reference to mobile and wireless computing?

Select one:

a. Wireless technology is any type of operation accomplished without the use of a hard-wired connection

b. Mobile technology allows a user to download software to a laptop or cell phone for portable reading or reference

c. Wireless technology is any type of operation accomplished with the use of a hard-wired connection

d. Mobile technology can travel with the user

Question 18

Answer saved

Marked out of 1.00

Flag question

Question text

What is the type of knowledge that consists of anything that can be documented, archived and codified, often with the help of IT?

Select one:

a. Tacit knowledge

b. Explicit knowledge

c. Virtual knowledge

d. Pure knowledge

Question 19

Answer saved

Marked out of 1.00

Flag question

Question text

An extranet is not available for use by a ______________.

Select one:

a. customer

b. partner

c. competitor

d. supplier

Question 20

Answer saved

Marked out of 1.00

Flag question

Question text

Intermediaries are agents, software or businesses that provide a trading infrastructure to bring buyers and sellers together. Which of the following businesses do not fall into the category of intermediary?

Select one:

a. eBay

b. Dentist

c. Car dealership

d. Travel agent