Suljettu

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.

Taidot: Tietokannan hallinto, Tietokantakehitys, Tietokantaohjelmointi, Oracle, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) bengaluru, India

Projektin tunnus: #18847634

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 1 päivässä
(6 arvostelua)
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 1 päivässä
(12 arvostelua)
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 1 päivässä
(6 arvostelua)
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 Lisää

$23 USD 1 päivässä
(3 arvostelua)
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 Lisää

$25 USD 1 päivässä
(2 arvostelua)
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 2 päivässä
(1 arvostelu)
0.8
ab18dev

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

$30 USD 1 päivässä
(2 arvostelua)
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 Lisää

$30 USD 2 päivässä
(1 arvostelu)
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 5 päivässä
(0 arvostelua)
0.0
$25 USD 10 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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 Lisää

$25 USD 1 päivässä
(0 arvostelua)
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 Lisää

$35 USD 10 päivässä
(0 arvostelua)
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 Lisää

$35 USD 2 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
0.0