Đã hoàn thành

Database example

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.

Kĩ năng: SQLite, Relational Databases, Computer Science

Về khách hàng:
( 4 nhận xét ) Melbourne, United States

ID dự án: #26145649

Được trao cho:

databasedba

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

$140 USD trong 2 ngày
(0 Đánh Giá)
0.0

9 freelancer chào giá trung bình$143 cho công việc này

ahmostafa0

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

$300 USD trong 1 ngày
(8 Nhận xét)
3.6
Saif100424

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

$139 USD trong 4 ngày
(0 Nhận xét)
0.0
OlehPro

Hello client I am very interest in your project. I am an expert of Software, I mastered in design and maintain of Relation Database. I will satisfy you with my good working result. So let's discuss more details over ch Thêm

$140 USD trong 7 ngày
(0 Nhận xét)
0.0
DRG1990

Hello I have read your job description carefully. I am a web expert with 10 years of experience in PHP, MySQL, Javascript, HTML, CSS. Also, I have rich experience in SQL Query. So I am interested in and I am confident Thêm

$100 USD trong 1 ngày
(0 Nhận xét)
0.0
Deep196

do my best to complete work on time as specified by recruiter. I pledge to work should be done with best mannered

$56 USD trong 7 ngày
(0 Nhận xét)
0.0
jmayankjain

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

$180 USD trong 5 ngày
(0 Nhận xét)
0.0
JSComputerTech

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

$90 USD trong 2 ngày
(0 Nhận xét)
0.0