Construct a small commercial database and demonstrate its functi
- or -
Post a project like this1845
€80(approx. $89)
- Posted:
- Proposals: 8
- Remote
- #2481625
- OPPORTUNITY
- Awarded
Web Development, Graphic Designer, C/C++ Programmer, Computer Scientist,Translator, Logo Designer
Multan
Researcher, Data base building, Lead generation, E Mail database, Data Entry, Research base writing, Market Research,
Bay Minette
3146592875625211818725820137237606288702937974837804
Description
Experience Level: Entry
Objective: Construct a small commercial database and demonstrate its functionality
1. Identify and examine three different websites which offer an on-line purchasing facility. Look particularly at the interactive pages used for the purchasing function and from these list all the fields that have to be completed by the purchaser for each site. (Note that you do not have to limit yourself to data-entry fields, analyse the websites for other possible attributes.) From your three sets of attributes, produce one generic list. Justify why you have included some attributes, and why you have rejected others.
2. From this generic list, construct an Extended Entity Relationship (EER) diagram for a database that would support an on-line purchasing facility. Construct a supporting Table Schema. Explain your thinking, and any assumptions made in this process.
3. Using the software provided, build tables to represent the entities from the Table Schema. Invent data to represent stock for the tables created. Insert six records into each table. Provide screen dumps of all the CREATE TABLE statements and the completed tables.
4. Design five data retrieval queries for this database that demonstrate your skill with SQL and run them. Provide screen dumps to show each query and its output, explain for each query what it was intended to do, and how the data from the tables proves its successful operation. Demonstrate complex system queries.
5. Write a reflection for your database design and the chosen queries.
It has to be completed until 4th August.
1. Identify and examine three different websites which offer an on-line purchasing facility. Look particularly at the interactive pages used for the purchasing function and from these list all the fields that have to be completed by the purchaser for each site. (Note that you do not have to limit yourself to data-entry fields, analyse the websites for other possible attributes.) From your three sets of attributes, produce one generic list. Justify why you have included some attributes, and why you have rejected others.
2. From this generic list, construct an Extended Entity Relationship (EER) diagram for a database that would support an on-line purchasing facility. Construct a supporting Table Schema. Explain your thinking, and any assumptions made in this process.
3. Using the software provided, build tables to represent the entities from the Table Schema. Invent data to represent stock for the tables created. Insert six records into each table. Provide screen dumps of all the CREATE TABLE statements and the completed tables.
4. Design five data retrieval queries for this database that demonstrate your skill with SQL and run them. Provide screen dumps to show each query and its output, explain for each query what it was intended to do, and how the data from the tables proves its successful operation. Demonstrate complex system queries.
5. Write a reflection for your database design and the chosen queries.
It has to be completed until 4th August.
George K.
95% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
70%
Last project
23 Aug 2021
Greece
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies