Database example
Ngân sách $30-250 USD
Job Description:
Needed By 11pm tonight EST
Design an ER-Model and draw the ER-Diagram. For each entity propose at least 3 attributes. You should have at least a weak entity, a generalization-specialization hierarchy, and a multivalued attribute.
Propose a Relational model (a set of tables) implementing your ER-diagram, and draw the relational diagram.
Write a Relational Algebra Query to retrieve the list of exams available for student “Isabella”, listing: the class name, semester, name of test, deadline of test, type of test, the number of possible attempts, the last attempt already taken, and the grade.
Write a Relational Algebra Query to retrieve the list of test attempts already taken in the past by student “Bader”, listing: the class name, semester, name of test, deadline of test, test type, the attempt number, the date of the attempt, and the grade.
Write a Relational Algebra Query to retrieve the list of tests in the classes of instructor “Silaghi”, listing: the class name, semester, name of test, deadline of test, and the date of the last attempt by some student.
Write a Relational Algebra Query to retrieve the list of student names for all students who took all tests posted by instructor Silaghi.
Write a SQL DDL query for creating the table for entity test.
Write a SQL query to retrieve the list of exams available for student “Erika”, listing: the class name, semester, name of test, deadline of test, type of test, the number of possible attempts, the last attempt already taken, and the grade.
Write a SQL Query to retrieve the list of student names for all students who took all tests posted by proff.
Được trao cho:
Dear Hiring Manager, I am an Oracle Certified Database Professional (OCP). I have complete masters in computer science. I am a database professional with 15 years’ experience. My background includes Sql, MySQL, Pl Sql, Thêm
9 freelancer chào giá trung bình$143 cho công việc này
Hi Dear I'm a CCIE Network Solutions Engineer working at Cisco Golden partner Specialized in Cisco , Microsoft Based Solutions and linux. Working in Networking and Technical Training Fields. Core Technical Skills: - Thêm
I have understood your project perfectly. Please come into the chatbox for further discussion. We are a group of Writer and Designer with 6+ years of expertise. Special things: #Expert Person to handle your project Thêm
do my best to complete work on time as specified by recruiter. I pledge to work should be done with best mannered
Hi, As per my understanding I have to create an ER Diagram for showing the relationship between the entity for which we have to write the query. If my understanding is correct please send me message so that we can dis Thêm
Greetings: Dear sir, I have five year experience of teaching of Data Base and Advance Data Base in higher level Classes as lecturere. I have studied your Case study deeply. I will handle your task with my best efforts Thêm
