Terminé

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.

Compétences : SQLite, Relational Databases, Computer Science

Concernant le client :
( 4 commentaires ) Melbourne, United States

Nº du projet : #26145649

Décerné à:

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, Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(0 Commentaires)
0.0

9 freelances font une offre moyenne de 143 $ pour ce travail

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: - Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0