Closed

Enhanced Entity Relationship (EER) diagram, SQL Statements (DDL, DML, and Select),Power point,

A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name,j Address, City/State/Zip, and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, and volunteers have only a Skill attribute. Donors have only a relationship (named Donates) with an Item entity type. A donor must have donated one or more items, and an item may have no donors, or one or more donors. There are persons other than employees, volunteers, and donors who are of interest to the organization so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to two or more of these groups (e.g., employee and donor).

Design your own Database project for specific system above. Your project should include the following:

1. Draw an EER diagram for the above problem using this text’s EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor to captures all requirements.

2. A full DDL statements that includes all primary keys, unique keys, foreign keys, and, check constraints.

3. You should fill your tables with many rows (main transaction tables at least 100,000 records). It is allowed to use import data utilities(like excel ….etc), or writing a transcript insert statements to create random data.

4. Writing 5 complex quires to retrieve main reports you find they important in the system.(The complex queries means it should include at least one of or more of the following: aggregate function, inline queries, correlated inner query, different types of joins, set operations etc).

5. Analysis the performance of the suggested queries and apply different techniques to enhance quires like: indexing, De-normalization.

6. Re-measure performance after applying different techniques and criticize the drawbacks of each techniques and the obtained enhancement.

Skills: Database Administration, Database Development, Database Programming, Oracle, SQL

See more: entity relationship diagram catering services, example entity relationship diagram catering, entity relationship diagram creator, sql commands ppt, sql queries examples with answers ppt, sql ppt slideshare, advanced sql ppt, sql queries pdf with examples, sql server basics ppt presentation, entity relationship diagram sas, aurion entity relationship diagram, sip entity relationship diagram, entity relationship diagram airline case study, entity relationship diagram airline reservation system, entity relationship diagram project, entity relationship diagram gymnasium booking system, entity relationship diagram case study, entity relationship diagram cinema, entity relationship diagram catering order system, entity relationship diagram catering system

About the Employer:
( 1 review ) bengaluru, India

Project ID: #18847634

16 freelancers are bidding on average $44 for this job

utkarshkatiyar19

Hi I'm an expert in making ER diagrams. I'm sure that I can easily do this project. We can have a about it. Thanks..

$80 USD in 1 day
(6 Reviews)
4.2
kaindo2017

I'm a Bsc degree holder in computer science. I have worked on many papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.

$55 USD in 1 day
(12 Reviews)
4.1
mukesh30march

helllo i read all requirement please share more detail i did 5 similar task i will provide 5 star rating work thanks

$55 USD in 1 day
(6 Reviews)
3.2
waseemsaleemg

Hi Dear, Our best concern is to follow your requirement and deadline and we will do our best for the success of your project. Feel free to send message to discuss your project with us. Thank you very much! Surely, we More

$23 USD in 1 day
(3 Reviews)
3.2
amit0423

Hi, I would love to assist you in making ER diagrams based on your provided requirements, then I can check with SQL queries. Please initiate the chat to discuss this further. I am full stack developer and have been d More

$25 USD in 1 day
(2 Reviews)
3.0
amnajavaid912

Hello, I am a Software Engineer. I'm experienced in software designing. I can make database assignment done. Please take a look on my porfile for sample work.. Looking forward to work on your project. Thanks.

$60 USD in 2 days
(1 Review)
0.8
ab18dev

Hi, I have extensive experience working on similar assignments. Would be able to complete the project in a day.

$30 USD in 1 day
(2 Reviews)
1.1
Satheeshtetro

Hi, Hope you are doing good. I have gone through the project and requirement details carefully. As 7+ experienced SQL server developer I am damn sure I can finish this project with 200 % efficiency within the speci More

$30 USD in 2 days
(1 Review)
0.4
fromano

Can deliver all requests. If you have a table with all data fields already populated, can do for 50 usd

$111 USD in 5 days
(0 Reviews)
0.0
$25 USD in 10 days
(0 Reviews)
0.0
paraslawnmover

Hey.... I have done this type of activity in my project. I have 4 years of experience. If you are interested, let's discu this further.

$25 USD in 2 days
(0 Reviews)
0.0
mhaskar1973

I have total of 20+ years of experience in writing sql code. Once the project is awarded, with some initial understanding, can complete this project in no time.

$55 USD in 1 day
(0 Reviews)
0.0
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB desi More

$25 USD in 1 day
(0 Reviews)
0.0
KomalMangla19

A summary of my technical skills are listed below, I have:  SQL Server 2005/2008/2012 -Querying, Create Views, Procedures, Cursor, DB creation, Backup, Restoring, Job Scheduling,Database Mail Configuration,Indexing More

$35 USD in 10 days
(0 Reviews)
0.0
miguelllado

More than 15 years of experience in data modeling. Successful ERP modeling. Great experience in the use of OPEN technologies. Deep knowledge of the design phases of data structures, from conceptual modeling to performa More

$35 USD in 2 days
(0 Reviews)
0.0
SaharovIlya

I've been working with databases since 2010. Thank you for choosing me. Looking forward to working on your project.

$35 USD in 2 days
(0 Reviews)
0.0