database Sql -- 2

Përfunduar Postuar 5 vite mё parё Paguhet në dorëzim
Përfunduar Paguhet në dorëzim

Design and Construct a database system for a business case for at least three entities (tables). The tables should contain a reasonable number of constraint tuples (rows), not too few and not too many. The following properties should be considered when submitting the final work:

1. Uniqueness: new and no duplicates

2. Originality: Creative effort invested by group members into the requirements that gives them a new quality or character. The problem statement contains indicators for freshness of aspect, design, or style.

3. Completeness: The state of being complete.

4. Readability: The ease in which anyone can read and understand the work.

5. Creativity: Artistic or intellectual inventiveness. We can define creativity as innovation which refers to the introduction of novel things.

Final work should include the following:

PART I: Project description and data modeling (total points 20)

1. Write an executive summary of the business case ( Maximum of one page, 5 points)

2. Draw the Entity-Relationship model by showing all necessary attributes and identifiers and relationships (10 points)

3. Construct a data dictionary table of all attributes in tables (5 Points)

PART II: Implementation (Total points 70)

1. Create the tables identified in part I in SQL+ under Oracle (10 points)

2. Insert at least 20 rows in each table, and display the tables. (10 points)

3. Write at least 20 questions to display data from tables. Questions should span all topics covered in class (20 points)

4. Write the corresponding SQL statement for each question in step 3 and execute them. In this section, you should include a screenshot of your program’s output, based on the sample data that you provided. (30 points).

PART III: Self Reflection (Total points 10)

In this section, you should reflect on what you have learned in this project, and outline the challenges that you have faced while working on this project, and how you overcame them. Include contribution of each team members:

Zhvilim bazash të të dhënave Programim Bazash të Dhënash SQL

ID Projekti: #17164546

Rreth projektit

9 propozimet Projekti në distancë Aktiv 5 vite mё parё

Është zgjedhur fitues:

sku5551ed6fd9643

Hello. I read your job description and it was really excited. Because I am expert in this field. I started as a Database Development, Database Programming, SQL I have built Websites for Database Development, Databa Më shumë

$25 USD për 1 ditë
(0 Përshtypje)
0.0
swathi8118

Hi am a software developer by professionwith 6+ years of experience. I can take up this project and finish on time. Looking forward for a positive reply

$25 USD për 1 ditë
(4 Përshtypje)
2.3

9 profesionistë freelancer dërguan një ofertë mesatare prej $32 për këtë punë

jagdishbhatt38

I am having more than 9 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Më shumë

$40 USD për 2 ditë
(27 Përshtypje)
4.8
carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$55 USD për 2 ditë
(13 Përshtypje)
4.3
TalhaMunir07

STOP BEFORE MOVING Hi, My name is Talha Munir and I have done software engineering. This is my new profile but I have 5 year of experience here. I will not submit COPY PASTED bid I Will do all the three parts of you Më shumë

$45 USD për 3 ditë
(8 Përshtypje)
3.9
zajjithvedha

Hi, I have a good experience in Database Development and Database Programming, etc... But I'm a new freelancer so I doesn't have lot of reviews in these relevant skills. But I confirm you I can do this project very Më shumë

$25 USD për 1 ditë
(18 Përshtypje)
3.7
arjun366333

Ready to start the work to Design and Construct a database system for a business, We can discuss more over chat, Thanks Arjun S.

$25 USD për 1 ditë
(1 përshtypje)
1.8
animeshbadjatya

I have previously made the database for the car rental company. Please ping me if you want to know more about it. Thank you

$30 USD për 3 ditë
(0 Përshtypje)
0.0