Final June 2019, answers PDF

Preview

Summary

ANSWER SHEETCOURSE : DATABASE DESIGN AND DEVELOPMENT /DATABASE DESIGN AND APPLICATIONCOURSE CODE : ICT450 / ITSNAME : NIK ZAHARAH BT MOHAMEDSTUDENT ID : 2019229742GROUP : RCS2402BLECTURER : NOORFAIZALFARIDINSTRUCTION: 1. Please complete all your details in the above area. 2. Please modify the questi...

Description

1

ANSWER SHEET

COURSE

:

DATABASE DESIGN AND DEVELOPMENT / DATABASE DESIGN AND APPLICATION

COURSE CODE

:

ICT450 / ITS432

NAME

:

NIK ZAHARAH BT MOHAMED

STUDENT ID

:

2019229742

GROUP

:

RCS2402B

LECTURER

:

NOORFAIZALFARID

INSTRUCTION: 1. Please complete all your details in the above area. 2. Please modify the question area to fit your answer. No maximum sheet limitation for this answer sheet. This template is just a guidance. 3. Answer all questions based on the QUESTION PAPER. 4. Name your answer sheet file as ICT450_FinalTest_StudentID. Example: ICT450_FinalTest_2011029382. 5. Convert your file as PDF for your submission.

QUESTION

FULL MARKS

1

20

2

20

3

20

4

20

5

20

TOTAL

100

YOUR MARKS

2

QUESTION 1 (20 marks)

a) A DBMS plays a crucial role in both the creation and management of data. A DBMS can be used to built many different types of database. Each database stores a particular collection of data and is used for a specific propose. It also provides the end user with a single, integrated view of the data, and translates all applications it receives into complex operations that fulfil those requests.

b) It has conceptually is simple but computers lacked power to implement the relational model .Besides, today microcomputers can run sophisticated relational database software. It also can facilitate poor design and implementation because may promote “redundancy of information” problem.

c) i.

Table Relational schema Stores a collection of related entities

ii.

Weak entity

iii. Because primary key in table CLIENT, COURT, LAWYER have in table CASE. So, it has primary key that is partically derived from the parent entity in relationship. It also existence-dependent.

iv. Each client can have many lawyers and each lawyer can have many clients also. Each client makes many cases and each case made by a client.

3

Each lawyer handles many cases and each case handled by a case. Each courts settles many cases and each case settled by a court.

4

QUESTION 2 (20 marks)

a) Analysis -discover what the company the company’s operational components are, how they function, and how they interact Detailed system design -finding precise answer is important and defining problems does not always lead to perfect solution -designer must ensure that database system objective correspondent to those envisioned by end user Implementation -

Hardware, DBMS software and application are installed and database design is implemented.

Maintenance -make it possible to produce better systems within reasonable amount of time and at a reasonable cost

b) Multimedia database is the collection of interrelated multimedia data that includes text, graphics (sketches, drawings), images, animations, video, audio etc and have vast amounts of multisource multimedia data.

Static media (time-independent: image and graphic object). Dynamic media (time-dependent: audio, video and animation). Dimensional media (3D game and computer aided drafting programs).

c) Data redundancy occur but when Ms. Parker update his number phone, the number phone do not update whole table, just update the updated table only.

5

6

QUESTION 3 (20 marks) a)

Normalization is a process for evaluating and correcting table structures to minimize the data redundancies.

b) Evaluate Primary Key Assignment Identify new attribute Identify new relationship Refine attribute atomicity

c)

Zero-normal form because the integrity rule are not fulfill

d)

1NF

BOARDING (CustIC, CustFirstName, CustLastName, {FlightID, PlaneType, Capacity, DestinationID, DestinationName}, Date, Time, Seat) 2NF FLIGHT(FlightID, PlaneType, Capacity, DestinationID, DestinationName)

BOARDING (CustIC, CustFirstName, CustLastName, Date, Time, Seat) 3NF FLIGHT(FlightID, PlaneType, Capacity)

BOARDING (CustIC, CustFirstName, CustLastName, Date, Time, Seat) DESTINATION (DestinationID, DestinationName)

7

8

QUESTION 4 (20 marks)

a) i.

ALTER TABLE ATHLETE ADD COLUMN Ath_Weight decimal (5,2)

ii.

SELECT AVG (Ath_Weight) AS Average FROM ATHLETE

iii. SELECT COUNT (CompetitionID) AS Average FROM COMPETITION WHERE Date = ‘2019’;

iv. SELECT DISTINCT VenueID FROM VENUE WHERE Capacity > 5;

b)

i.

CREATE TABLE ACTING roles varchar, year_release date, rating varchar, directorID number NOT NULL,

9

actorID number NOT NULL, movieID number NOT NULL,

ii.

SELECT directorName FROM MOVIE M , DIRECTOR D WHERE M.directorID = D.movieID AND HAVING COUNT (movieID) >4 AND date_directed = ‘2019’;

iii. SELECT DISTINCT actorName FROM ACTOR WHERE actorName =’Nur’ OR ‘Syafiq’ ;

iv.

QUESTION 5 (20 marks)

10

a)

b) 1- list of albums that produced by Seniwara Sdn. Bhd. 2- list of details about the member that participates in a Seniwara Sdn. Bhd.

11

END...