Read the following case study which describes the data requirement for a magazine distributor company. The...

 

Transcribed Image Text:

Read the following case study which describes the data requirement for a magazine distributor company. The magazine distributor company has several branches throughout Malaysia. The data identifying each branch address, telephone number (maximum up to 2 telephone numbers), and fax number. Each branch is given a branch number which is unique throughout the company. Each branch has staff and the data identifying on each staff is the name, position, salary, and the data a staff joined. Each member of staff is given staff number, which is unique throughout the company. The company distributes a variety of magazines, which are identified by the magazine code. Data identifying each magazine are number of issues per year, price of each issue, and nature of language. When a customer orders a magazine, order duration, total payment, and payment method are recorded. Each customer is given a unique number throughout the company. The data accorded to each customer is the name, adders, and contact number. Number of orders from each branch varies each month; therefore, month and year (as single attribute), and number of copies are recorded for each branch one each magazine title. Question 1 (a) Database design consists of three phases which are known as conceptual, logical and physical. Use a diagram to illustrate this database modeling concept. Compare and contrast all the three phases with the use of MAGAZINE DISTRIBUTOR COMPANY as the example. [10 marks] (b) Describe the following with examples when tables are designed and created (use the scenario): [6 marks] i. ii. iii. Data Manipulation Language (DML) Data Definition Language (DDL) Data Control Language (DCL) [2 marks] [2 marks] [2 marks] (c) Describe with an example, the approach taken for the handling of data in early file-based systems that are used before the MAGAZINE DISTRIBUTOR COMPANY proposal. [4 marks] Read the following case study which describes the data requirement for a magazine distributor company. The magazine distributor company has several branches throughout Malaysia. The data identifying each branch address, telephone number (maximum up to 2 telephone numbers), and fax number. Each branch is given a branch number which is unique throughout the company. Each branch has staff and the data identifying on each staff is the name, position, salary, and the data a staff joined. Each member of staff is given staff number, which is unique throughout the company. The company distributes a variety of magazines, which are identified by the magazine code. Data identifying each magazine are number of issues per year, price of each issue, and nature of language. When a customer orders a magazine, order duration, total payment, and payment method are recorded. Each customer is given a unique number throughout the company. The data accorded to each customer is the name, adders, and contact number. Number of orders from each branch varies each month; therefore, month and year (as single attribute), and number of copies are recorded for each branch one each magazine title. Question 1 (a) Database design consists of three phases which are known as conceptual, logical and physical. Use a diagram to illustrate this database modeling concept. Compare and contrast all the three phases with the use of MAGAZINE DISTRIBUTOR COMPANY as the example. [10 marks] (b) Describe the following with examples when tables are designed and created (use the scenario): [6 marks] i. ii. iii. Data Manipulation Language (DML) Data Definition Language (DDL) Data Control Language (DCL) [2 marks] [2 marks] [2 marks] (c) Describe with an example, the approach taken for the handling of data in early file-based systems that are used before the MAGAZINE DISTRIBUTOR COMPANY proposal. [4 marks]

Answer rating: 100% (QA)

Solution a Database Design Phases Database design consists of three phases conceptual logical and physical Conceptual design is the process of understanding the business needs and requirements and tra... View the full answer