Reference no: EM132389253

MITS4003 Database Systems - Victorian Institute of Technology

2.2 Consider a database used to record the marks that students get in different exams of different course offerings (sections).
a. Construct an E-R diagram that models exams as entities, and uses a ternary relationship, for the database.
b. Construct an alternative E-R diagram that uses only a binary relationship between student and section. Make sure that only one relationship exists between a particular student and section pair, yet you can represent the marks that a student gets in different exams

2.4 An E-R diagram can be viewed as a graph. What do the following mean in terms of the structure of an enterprise schema?
a. The graph is disconnected.
b. The graph has a cycle.

3.2 The Gill Art Gallery wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be bought and sold several times. In other words, the gallery may sell a painting, then buy it back at a later date and sell it to another customer.

3.2 The Gill Art Gallery wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be bought and sold several times. In other words, the gallery may sell a painting, then buy it back at a later date and sell it to another customer. Normalize up to third normal form.

3.4 What conditions must the multivalued dependencies (if any) satisfy for a relation to be in 4NF?

4.4 List out employee details, which are not living in city, that have ‘le' character anywhere in the name of city.

4.7 Display all the orders detail that have orderdate in between '1997-09-25' to '1997-12-30'.

4.9 List out information about the latest order for each customer

5.2 Display orders which are placed by customers, use Left Outer Join

5.5 List the shipper name and the number of orders shipped by each shipper, use Inner Join.

5.6 Display all customers details (who have placed orders) and orders details which are placed by customers, use Right Outer Join.

5.9 Retrieve three characters from the employees' first names, starting at the third character (should be in lower case) and next two characters must be upper case (example: If first name is "Nancy" then output should be nCY).

7.1 Generate the Rules based on following sample data.

7.2 Generate the Classification Rules based on following sample data.

Attachment:- Activities.zip