[]

MYSQL Database Bir Kaç Tablo Ve İstenen İşlemler Yaptırılacak

Son Teslim Tarihi: 03 Temmuz 2020 23:00
Bilgisayar Yazılım
Elimde Tablo yapısı ( excell halde ) er diagramları hazır aşağıdaki işlemler eklenecek
+ Define the functional dependencies in your
tables, show them on your relations and check if
they are at least 3NF.
+ Define all integrity constraints that your
database needs to have (e.g. Foreign keys) and
what are the actions you are taking on Delete /
+ Install MySQL on your computer and create the
tables that you have designed in your second
report.
+ Populate these tables with some sample data:
-at least 10 users
+Write the SQL queries that are required for each of your
Write the Relational Algebra of your above Queries
+Test whether your queries are running or not on the data
that you have uploaded to your database and get
screenshots of the results, place them on your report as
figures.
+Add your Queries and your Relational Algebra to the
relevant section where you are describing that CA on your
report together with the above screenshots of the SQL
results.
+Create/declare 2 Trigger for your database.
+The trigger needs to be related to the CAs that you
have defined (but this is not a requirement)
+Test whether your trigger is working.
+Add the trigger to your report to the section where you
are describing this CA
+Clearly state why you designed such a trigger, what are
the advantages of this trigger?

Bu Görev Yayında Değil

Yorumları görmek için giriş yapmalısın !