In Progress

Database project

This project consists of two phases: data modeling using E-R approach, design and implementation of a tutoring database. You should include the following entities: STUDENT, TUTOR, COURSE, SESSION, and REQUEST. You need to decide where should the following attributes belong:

TutorHireDate, CourseName, CourseDescription, StudentEmail, StudentPhone, SessionDate, SessionTime, RequestDate, RequestStudentEmail, RequestStudentID, RequestStudentName. You may add to the entities any other reasonable attributes.

Use the following information:

• A tutor can tutor more than one course. A course can be tutored by more than one tutor. A tutor must be assigned to tutor at least one course, but a course may not necessarily be tutored by any tutor.

• A student can enroll in many courses and one course can contain many students.

• A session is used to define the tutoring sessions themselves. It needs a course and a tutor. However, not every session that is available will be taken by any student.

• Request allows students to request tutoring in areas where it is not already provided.

Your professor is anxious to see some progress on your database. I want your database to be in place by November 30, 2016. It is time to data model and design the tutoring database.

To do

1. Define your entities, all attributes and identifiers.

2. Determine all relationships that exist between entities, describe their types, minimum and maximum cardinalities.

3. Create a logical model using crow’s foot notation in ERwin.

4. Add all the entities and their attributes.

5. Identify the key identifiers for each entity and the foreign keys.

6. Analyze the diagram.

Have another student or a group review it for the following:

Are all the major components of your model represented by domain entities?

Does each entity contain the appropriate attributes to fully describe?

Does every entity have an appropriate identifier defined?

Are all many-to-many relationships resolved into one-to-many relationships by intersection tables? Is the appropriate entity is defined as the one side of a one-to-many relationship?

Transform the diagram into a set of tables (design). Indicate primary keys and foreign keys.

Create these tables on Oracle Database and insert at least five rows in each table. You will be asked to execute some SQL queries to verify your database design on November 30, 2016 such as:

Select count(*)

from TUTOR;

Use the following resourses to review how to create tables and insert data in Oracle Database:

Go to the following website to download the online chapter 10B (Managing Databases with Oracle Database):

[url removed, login to view]

page 41 incudes examples of how to create tables.

Page 52 includes examples of how to populate tables by using SQL INSERT statements.

Skills: Database Development, Database Programming, SQL

See more: software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, project database fact sheets bidding jobs, project database manager, database exist php, introduction online bookstore project database systems, astroempires project database, software write protect software, bebo database data types, filemaker project database sound, project database files mega retail store, free project database vb6, java exe project database, software write technical manual

Project ID: #12232549

Awarded to:

sofyasultana

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0

3 freelancers are bidding on average $75 for this job

amitarai

Hello My name is Pranav I have checked the details shared by you will do done exactly what you want Please consider my bid and we can discuss more so that i can assist you in better way our services always with More

$50 USD in 5 days
(1 Review)
0.0
ksinghrajeev

Hello There, Here are some of my work examples. Project Report Automation - https://www.dropbox.com/s/tt0q9qhfq3s4izm/eBird%20FEP%20Plan%2012_Feb_15.xlsm?dl=0 Log Report Automation - https://www.dropbox.com/s/ More

$150 USD in 5 days
(0 Reviews)
0.0