Question: QUESTION 2 a) Conceptual design is the first stage in the database design process. The output of this process is a conceptual data model

QUESTION 2 a) Conceptual design is the first stage in the database

QUESTION 2 a) Conceptual design is the first stage in the database design process. The output of this process is a conceptual data model that describes the main entities, attributes, relationships, and constraints of a given problem domain. Discuss FOUR (4) steps with their activities in conceptual design phase. (8 marks) b) Mobile Database is a database that resides on a mobile device such as smart phone and notebook. Describe FOUR (4) challenges in Mobile Database. Give an example for each challenge. (8 marks) c) Explain TWO (2) advantages of database system approach over file-based approach. (4 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You will be tasked with a 2000-word reflective essay. You are required to critically evaluate the qualities and skills that operations management professionals need to help companies solve...

Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Database exists as an important part of an information system. As you may recall, information systems also contain people, procedures, input data, output data software and hardware. Your database...

Needs correct answer for the 18 multiple choice questions on Accounting Information & Control Systems (AIS) home / homework help / questions and answers / business / accounting / 1. of the following,...

please answer Question 2.1 and 2.2 PROJECT 2: INFORMATICS 2A QUESTION 1 (20) 1.1 Lock granularity specifies the level of lock use. List and explain the four levels of lock granularity. 1.2 Deadlock...

Overview The purpose of this assignment and assignment 2 is for you to practice the four steps of the database design process. In this assignment, you will design an entity-relationship (ER) diagram...

Please, I need answers to these questions 4,5,6 (90 Marks) In the first assignment of System Analysis and Design Concepts for the current semester, you have already completed the initial...

You are a small database consulting company who designs and develops databases for small to medium sized businesses. You have now been hired to design and implement a database system for the dream...

1. Answer the following two questions. a. Identify and describe two types of facility you would expect to be provided in a multi-user DBMS. Identify two types of facility that not be needed in a...

You wish to accelerate a small merry-go-round from rest to a rotational speed of one-third of a revolution per second by pushing tangentially on it. Assume the merry-go-round is a disk with a mass of...

1-Costs incurred by the lessor that are associated directly with originating a lease and are essential to acquire that lease are called initial direct costs. Initial direct costs are expensed at the...

Alli 4 of 9 1 Concepts completed ( i ) Multiple Select Question Select all that apply The general ledger can be used to determine which of the following ( select all answers which apply ) : which...

James Hardy recently rejected a $20,000,000, five-year contract with the Vancouver Seals. The contract offer called for an immediate signing bonus of $5,000,000 and annual payments of $3,000,000. To...

Newport Department Store is considering development of an e-commerce business. The company estimates that development requires an initial outlay of $1,470,000. Other cash flows will be as follows:...

Tanya Sinclair, owner of Sinclair Fine Wine, is considering investing $87,930 in a temperature-controlled wine storage room. She plans to rent space to customers and expects to generate $25,000...

Write 2 page paper over IFRS and the affects it will have on the accounting profession over the next 5 to 10 years.

The editor of Spunk magazine is considering three alternative prices for her new monthly periodical. Her estimate of price and quantity demanded are: Price Quantity Demanded $7.95 ......... 25,000...

The return of goods to the supplier will affect the purchase account. Question 27Answer True False

Examine Nikes Form 10-K report in Appendix C, focusing on the income statement and balance sheet. Answer the following questions: 1. Nike used the term consolidated to describe its financial...

Kester Electronics had a fixed factory overhead budget for 20X0 of $72 million. The company planned to make and sell 9 million units of a particular communications device. All variable manufacturing...

Distinguish between direct, indirect, and unallocated costs.

Explain the perspective that tougher enforcement of drug laws for cocaine or other drug laws may actually increase the crime rate. Use the concepts of demand, supply, and elasticity in your...

How does the pricing of medical care in the United States affect the quantity consumed?