CSC 8490: Database Systems

Fall, 2019
Homework

Table of Contents

Discussion of pending assignments:

Discussion is permitted, but everyone must write up their own assignment. Assignments that resemble each other will not be given any credit.

hw #1:

On this assignment you will read and report on an article or website. Here's the topic to research: One of the hot discussion topics these days is "NoSQL" data stores. Some folks feel that we should no longer be using (or teaching!) relational databases and SQL.

Find an article or website that addresses this controversy. It shouldn't be a Wikipedia entry, but it's OK if you find it through Wikipedia (even though googling it is probably sufficient). Write a brief (font size at least 12, limit one page) summary of the article. Include whatever details you can glean as to date, author, etc. Address these points:

Remember, for this and all homework submissions (unless some graphics are necessary) remember to use a word processor. Please submit your assignments by uploading it to Blackboard before class time on the due date.

hw #2:

Draw two ER diagrams for the enterprise described below: one using standard (Chen) notation (that one is hw #2), and one using ordered pair (Merise) notation (this one being hw #3). Indicate clearly which is which. Remember to indicate keys and relationship classifications in the diagram. Use your common sense on any classifications that aren't made explicit in the specs. Don't add any more ingredients than are described here. If you can, use software (e.g., MS-Visio, freeware, Paint) to generate the diagram. You can probably use MS-Word or MS-PowerPoint, too. At any rate, make sure it's very legible.

If you have questions about these specs, I'll play the role of the client who will resolve them.

So here's the enterprise: it's a travel agency that keeps track of its clients and their preferences. Each client is identified by her/his unique email but also has a name and telephone number. Airlines are identified by their URL's, but they also have a home airport and a unique name. Clients might have frequent flyer accounts with various airlines, in which case we keep a record, for each such airline, of their membership number with it. Vacation destinations have an ID and a name. Each is located in a unique country, for which we note the country name and currency. Not every country in our list might have a vacation destination, though. Now, for each client and destination, there's a unique airline the client prefers for that destination. Many clients might prefer the same airline for a given destination, and a client may prefer the same airline for many destinations. Some airlines aren't preferred for anywhere. Make "Preference" a ternary relationship type among three obvious entity types.

hw #3:

This is the Merise-style ERD (see the description above).

hw #4:

This assignment is or will be posted on Blackboard

hw #5:

This assignment is or will be posted on Blackboard

hw #6:

This assignment is or will be posted on Blackboard

hw #7:

This assignment is or will be posted on Blackboard

hw #8:

This assignment is or will be posted on Blackboard

hw #9:

This assignment is or will be posted on Blackboard

hw #10:

This assignment is or will be posted on Blackboard

hw #11:

This assignment is or will be posted on Blackboard

hw #12:

This assignment is or will be posted on Blackboard

hw #13:

This assignment is or will be posted on Blackboard

hw #14:

This assignment is or will be posted on Blackboard

hw #15:

This assignment is or will be posted on Blackboard

hw #16-#17:

This assignment is or will be posted on Blackboard

hw #18:

This assignment is or will be posted on Blackboard

hw #20:

This assignment is or will be posted on Blackboard

hw #21:

This assignment is or will be posted on Blackboard

hw #22:

This assignment is or will be posted on Blackboard

Back to CSC8490 home page