Database Systems - Loyal Academy

1.) Discuss two reasons to use the Entity Relationship (ER) Diagrams?

Question

2.) Contrast DELETE and TRUNCATE commands? 3.) Consider relation R=(A,B,C,D) with the following Functional Dependencies (FDs) AB C, C D and D A a. List all candidate keys of R. b. Is R in 3NF? or BCNF? 4.) Define Denormalization?

COLLEGE, Database Systems, Diploma Programmes, ICT 2 years 0 Answers 29 views Enlightened

1.) List two data manipulation (DML) commands in SQL.

Question

2.) Discuss two characteristics of DBMS. 3.) Compare two differences between File system and DBMS. 4.) Give a brief note on the term data independence in the context of relational databases.

COLLEGE, Database Systems, Diploma Programmes, ICT 2 years 0 Answers 50 views Enlightened

The following tables form part of a database held in a relational DBMS.

Question

Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest (guestNo, guestName, guestAddress) Hotel contains hotel details and hotelNo is the primary key. Room contains room details for each hotel and (roomNo, hotelNo) forms the ...

COLLEGE, Database Systems, Diploma Programmes, ICT 2 years 0 Answers 50 views Enlightened

Construct an ER diagram to model a database for the given information. Suppose that you are designing a schema to record information about reality shows on TV. Your database needs to record the following information:

Question

For each reality show, its name, genre, basic_info and participants name. Any reality show has at least two or more participants. For each producer, the company name, company country. A show is produced by exactly one producer. One producer ...

COLLEGE, Database Systems, Diploma Programmes, ICT 2 years 0 Answers 43 views Enlightened

Ask A Question

Highest points

BodMas
Enlightened 5122 Points
Erick
Professional 4743 Points
MB06
32 Points
Emmanuel Moruo
30 Points
Frank
28 Points

Register Now

Login

Lost Password

Add question

Login

Register Now