database Sql -- 2

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:

Habilidades: Desenvolvimento de Banco de Dados, Programação de Banco de Dados, SQL

Veja mais: sql online, sql union, sql interview questions, sql join, sql tutorial, sql examples, sql distinct, w3schools sql, oracle database, sql server, postgresql, design movie rental database sql, design hospital database sql, sql temp insert oracle, video rental store database sql script oracle, oracle database sql project, college assignment database sql oracle, insert xml file database sql server xml type, database backup coding design visual studio sql server, wcf application insert database sql 2008 vbnet query, database sql query oracle help, database user registration design sql

Acerca do Empregador:
( 1 comentário ) Abu-dhabi, United Arab Emirates

ID do Projeto: #17164546

Concedido a:


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 Mais

$25 USD em 1 dia
(0 Comentários)

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 em 1 dia
(4 Comentários)

9 freelancers estão ofertando em média $32 para esse trabalho


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

$40 USD in 2 dias
(27 Comentários)

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 in 2 dias
(13 Comentários)

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 Mais

$45 USD in 3 dias
(8 Comentários)

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 Mais

$25 USD em 1 dia
(18 Comentários)

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 em 1 dia
(1 Comentário)

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 in 3 dias
(0 Comentários)
$20 USD in 2 dias
(0 Comentários)