Question: Q1a What are the activities a Database Designer will do if using the SDLC to design a Database [10] Q1b List the five main components

Q1a What are the activities a Database Designer will do if using the SDLC to design a Database [10] Q1b List the five main components of Access Database and state their uses Q2 We want to represent information about products in a database. Each product has a description, a price and a code. Suppliers have addresses, phone numbers, and names. Each address is made up of a street address, a city, and a postcode. A supplier can supply many products at a request. Draw the E-R diagram.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Q1a Activities of a Database Designer in SDLC for Database Design 1 Requirement Gathering Understanding the needs of the stakeholders and gathering requirements for the database system This involves d... View full answer

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!

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...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Hi There I have attached an assignment where I need calculation only but you can help with the setup to inspired myself. It will be highly appreciated Please bear in mind that I have done it already...

Since Ryanair DAC's2 emergence as an upstart challenger to the Aer Lingus Ltd.-British Airways plc duopoly in the late 1980s, it had been both a consumer champion and antagonist; a technological...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

Introduction to Ridgeline Mountain Outfitters (RMO) Ridgeline Mountain Outfitters (RMO) is a large retail company that specializes in clothing and related accessories for all types of outdoor and...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

Solve the following problem to find the maximum profit by creating a spreadsheet and using Solver. Due to increased demand, a company is planning on making sanitizing wipes and hand sanitizer. The...

The following information has been extracted from the records of Due North Sales (DNS) Co.: January 1 January 9 January 15 January 25 Beginning Inventory Bought Sold 550 units @ $26 each 1,000 units...

Find the derivative of the following function. y = 5 6 x 1 d y d x = xample Get more help -

The Franklin Retail Company entered into the following transactions during 2007. [The transactions were properly recorded in real (balance sheet) accounts unless otherwise indicated.] Date...

The government has decided that the free-market price of cheese is too low. a. Suppose the government imposes a binding price floor in the cheese market. Draw a supply- and-demand diagram to show the...

A recent study found that the demand and supply schedules for Frisbees are as follows a. What are the equilibrium price and quantity of Frisbees? b. Frisbee manufacturers persuade the government that...

The Snedecker Corporation is considering a change in its cash-only policy. The new terms would be net one period. Based on the following information, determine if the company should proceed or not....

Lugar Corporation makes custom-order furniture to meet the needs of persons with disabilities. On January 1, 2018, the company had the following account balances: $37,800 for both cash and common...

Can we put that she will be making weekly payroll deductions inthe amount of $52.75 to the housing equalling $211.00 monthly

Quince Corporation has taxable income of $450,000 for its 2012 calendar tax year. Calculate the corporation's income tax liability for 2012 before tax credits. $_________

Jason and Mary are married taxpayers in 2012. They are both under age 65 and in good health. For this tax year, they have a total of $41,000 in wages and $500 in interest income. Jason and Mary's...

Sherry rents her vacation home for 6 months and lives in it for 6 months during the year. Her gross rental income during the year is $4,000. Total real estate taxes for the home are $950, and...

What is the first guideline for doing research with people? a. The rights and well-being of the participants must come first. b. Participants have to give informed consent. c. Deception cannot be...

In the definition of psychology, the term behavior means a. only animal behavior. b. internal, covert processes. c. outward behavior. d. overt actions and reactions.

Which of the following is an ethical consideration when using animals in research? a. Animals cannot be killed during the course of an experiment. b. Avoiding exposing them to unnecessary pain. c....