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:
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, Database Programming, SQL as well as I implemented Trading, Lending Bots.
I normally build cryptocurrency exchange website using Python+React framework.
Also I have strong skills in blockchain technology and ERC20 Smart Contract.
I can help you fully with my powerful knowledge.
Pls share more details via chat.
Thanks.
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 v 1 dni
5,0 (4 recenze)
2,3
2,3
9 freelanceři nabízejí v průměru $32 USD za tuto práci
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 utilizing my knowledge and skills.
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
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 your project which includes executive summary, ERD , data insertion and query in oracle.
I have been doing this for a lot of people like you. I will paste screenshots as well in the report. Cover page , executive summary will also be written
Please message me for further discussion
Thank you !!
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 well. Also if you want to negotiate budget and days I agree with it.
Regards,
Zajjith