Skip to content
This repository has been archived by the owner. It is now read-only.
master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
6.a
 
 
 
 
 
 

LiMo

LiMo: Basic LinkedIn and Moodle Database - 2019 (SQL)

Database model for the virtually integrated version of the popular web applications LinkedIn and Moodle (or any other learning management system).

Physical Model

  • Appropriate SQL scripts for creating the database and its relational model (Create, Alter Table)
  • Population the database with sample tuples using SQL scripts (Insert) (Used mock data that generated via Mockaroo.)
  • 3 Triggers for 3 Different tables (Trigger)
  • 3 Check constraints and 3 Assertions (Check Constraint, Assertion)
  • Sample insert, delete and update statements for 3 of the tables (Insert, Delete, Update)
  • 10 Select statements for the database you have implemented (Select)
    • 3 of them use one table
    • 4 of them use 2 tables
    • 3 of them use 3 tables
  • 5 Original Select statements (Select (Critical))

You can read analyzes of LinkedIn and Moodle.

About

LiMo: Basic LinkedIn and Moodle Database - 2019 (SQL)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages