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:
16 freelance font une offre moyenne de ₹2284 pour ce travail
Dear Sir, Nice to meet you. I am an expert mobile and web developer by profession from Poland. I have developed many apps for 7+ years and uploaded it on app store and play store and so have the rich experience Plus
Dear Sir/Ma'am, Greetings of the day! I walked through job description and I am capable to "Design and Construct a database system ". We are team of result-oriented professional with minimum 10 and maximum 22 yea Plus
I am a software developer by profession. I can complete the project in short time. Looking forward for a positive reply
I am a professional web developer and web desgin. Specifically I have good amount of experience in using php and plugins. I have worked with php at expert level. I have 5 years of experience with web developer and Plus
Hi, Hop you are doing good I have 8+ years in web designing & development with good experience in following skills ... 1. HTML5 2. CSS,CSS 3 & LESS 3. JS (Angular JS, Backbone JS,React JS, node.js, expresss Plus
I am an experienced SQL professional. Designing and architecting the solution from scratch is my forte. Please give me a chance and I’ll provide a robust and dynamic solution.
I have worked in Business Intelligence tools such as Tableau,MicroStrategy and Brio through the course of my career. I aslo have good knowledge in SQL and I would like to take part in a real time DB project to learn a Plus
Hello: I am a spanish computer engineer wich like me over all is to do Analysis and design tasks. Have 4 year of experience like .Net Analist and developeer. This is my first time in Freelancer and i would like to d Plus
Bipin Sahani is a Oracle and MySQL Senior Solutions Architect/Applications DBA/Core DBA with Oracle, MySQL Database and ERP practice. I am having more than 17 years of experience in the areas of Oracle Core Database Ad Plus
Good day............. I am ready to do that ............. you will not lose your money............... regards