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.
16 freelance font une offre moyenne de $44 pour ce travail
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..
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.
helllo i read all requirement please share more detail i did 5 similar task i will provide 5 star rating work thanks
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 Plus
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 Plus
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.
Hi, I have extensive experience working on similar assignments. Would be able to complete the project in a day.
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 Plus
Can deliver all requests. If you have a table with all data fields already populated, can do for 50 usd
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.
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.
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 Plus
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 Plus
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 Plus
I've been working with databases since 2010. Thank you for choosing me. Looking forward to working on your project.