Project #47093 - Database SQL

THIS IS A 4 PART HOMEWORK. I NEED 4 SEPERATE ZIP FILES FOR EACH PART

4 SEPERATE ZIP FILES.

 

 

 

 

PART 1 PART 1 PART 1

 

Homework Submission Requirements:             

  • Homeworks should be submited as an attached file in your assignment folder. text for coding and result of execution and MS Word format for documneting are preferred.  Data modeling diagram could be copied and pasted into a Word doc.
  • You must name your file to include your first initial  of your first name and last name.       
  • Part I is 4 points and Part II is 1 points.  Total is 5.   Quiz is not required for grading.

QI:  Data Modeling  

Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity. Then, develop an enterprise data model showing these entities and important relationships between them.

QII:  Lab 1

In this class, we need a functional database system to complete the tasks, such as project 2 and Learning SQL.  The school provides you with an Oracke database instance on NOVA unix server for this purpose.  You all should have your accounts set up.  What you need to do is to activate it for this class.

Lab 1 helps you to complete this task and also let you try a few simple SQL and SQLPlus commands.  You are welcome to do morebut not required.

Click here to access Lab 1 page

Homework and Lab references- this page provides you with links to UNIX commands, SQL*Plus commands and SQL with the examples.  You don't have to see everyone of them because there are overlaps between the same topics.  So use these links wisely.   These pages should help you with your labs and projects.

Click here to see Unix commands, SQL*Plus commands and SQL references

Optional FTP utilities and SQL Developer Setup

If you would like to try sftp tools, the following links provide you with setups.  Choose the one you would like to use. However, this part is absolutely optional, you don't have to try.  Also don't try them if you think you will have to spend a lot of time to learn these tools before you can use them to assist your study.

 

 

 

 

 

 

PART 2 PART 2 PART 2 PART 2 PART 2 PART 2 PART 2 PART 2 PART 2 PART 2 PART 2 PART 2 PART 2

 

Homework Submission Requirements:             

  • Homeworks should be submited as an attached file in your assignment folder. text for coding and result of execution and MS Word format for documneting are preferred.  Data modeling diagram could be copied and pasted into a Word doc.
  • You must name your file to include your first initial  of your first name and last name.       
  • Part I is 4 points and Part II is 1 points.  Total is 5.   Quiz is not required for grading.

QI  Data Modeling

For each of the following descriptio1ns:

a. A piano manufacturer wants to track all pianos it makes. Each piano has a unique serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and model. The company produces thousands of pianos of a certain model, and the design is specified before any single piano exists.

b. A vendor builds multiple types of tablet computers. Each has a type identification number and a name. The key specifications for each type include amount of storage and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet type. The same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer's unique code that identifies it.

perform the following tasks:

1. Identify the degree and cardinalities of the relationship. 2. Express the relationships graphically with an E-R diagram.

Document your work into a single, well-organized, well-written word document and submit no later than due date.

QII  Lab 2

In lab 2, you will  learn how to run a SQL script to create a sample database in your schema in  NOVA Oracle database.  You also start to learn simple SQL commands, such as select and insert ...

Click here to open Lab 2 instruction page

Homework and Lab references- this page provides you with links to UNIX commands, SQL*Plus commands and SQL with the examples.  You don't have to see everyone of them because there are overlaps between the same topics.  So use these links wisely.   These pages should help you with your labs and projects.

Click here to see Unix commands, SQL*Plus commands and SQL references

 

 

 

 

 

PART 3 PART 3 PART 3 PART 3 PART 3

 

 

Homework Submission Requirements:             

  • Homeworks should be submited as an attached file in your assignment folder. text for coding and result of execution and MS Word format for documneting are preferred.  Data modeling diagram could be copied and pasted into a Word doc.
  • You must name your file to include your first initial  of your first name and last name.       
  • Part I is 4 points and Part II is 1 points.  Total is 5.   Quiz is not required for grading.

Part I  Data Modeling

You are working for country club with thousands of members. You have been tasked with designing a database to keep track of the members and their guests.

The club keeps track of mail and telephone contact information, name and membership number. When a member joins the club they can become a social member with pool, racket ball and weight room privilieges or golf member which includes all of the social member privileges plus access to the golf course.

Develop, document and design an EER for this situation.

Submit your word document no later than the due date.

 

Part II  Lab 3

 

In lab 2, you will  learn how to edit and run a SQL script in your schema in  NOVA Oracle database.  You also continue to learn simple SQL commands, such as select and insert ...

 

Click here to access lab 3 description page

 

Homework and Lab references- this page provides you with links to UNIX commands, SQL*Plus commands and SQL with the examples.  You don't have to see everyone of them because there are overlaps between the same topics.  So use these links wisely.   These pages should help you with your labs and projects.

 

 

 

 

 

 

PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4 PART 4

 

 

This project allows students to demonstrate their skills in the area of designing relational databases to satisfy specific business rules and requirements. The deliverables for this project include an Entity Relationship Diagram and detailed documentation describing the database design and structure.

 

Project 1 Details:

In this project you will be provided with a description of an application (below) to create an entity-relationship diagram (ERD) and design accompanying table layout using sound relational modeling concepts and practices. The relationships between the entities and the attributes for the entities will be identified and described. This database will provide the foundation for the follow-on project. The following paragraphs provide the background and summary of the business requirements.

You are a database consultant with Ace Software, Inc. and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.

You sit down with Mom and Pop to discuss their business, and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices to them are based on the quantity of their shipment and the past business they have done with each company.

 

The price of a DVD for a movie might be different than the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors, and at different wholesale prices.

 

Each video and DVD has a unique identification number that Mom and Pop assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number Mom and Pop assign in addition to the title, and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom and Pop and the information from these catalogs must be included in the database.

 

Mom and Pop need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion there are discount prices for certain movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the academy awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. Mom and Pop need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc.

 

There must be no limit to the number of video and/or DVD copies of a movie that Mom and Pop can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and academy awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.

 

Using this information, you should:

Step 1) (7 points) Determine and list your entities. Then create relationship sentence pairs between those entities that are related.  You should not have any many-to-many relationships. 

Step 2) (13 points) Create an entity/relationship diagram (ERD) showing all your entities, attributes, and relationships. Sketch your ERD by hand or use a drawing program.  Your diagram must beon a single page.  All entities should be relatated to at least one other entity.  Your ERD should have all one-to-many relationships and not have any many-to-many relationships. 

Step 3) (5 points) Create metadata that describes the table created from each entity and the column created from each attribute in the ERD. Particular attention will be given to the proper specification of all primary key (via "PK") and foreign key (via "FK") columns in the table layouts. These should match your ERD exactly. 

Follow the procedures in the course modules and the Database Development Phases document for this project.

Submit everything for the above steps in a single Microsoft Word file to the LEO  Project #1 assignment link.  Make sure your work is neat and legible and your steps are in order.

 

Subject Computer
Due By (Pacific Time) 11/15/2014 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy