IS222 Assignment 2 Semester 1, 2017 Designing a Website for a client Due: 11:55

Question

IS222 Assignment 2      Semester 1, 2017
Designing a Website for a client
Due: 11:55 PM, Friday 19th May      Weight: 15% _____________________________________________________________________________________
Aim: To implement a Database based on a client’s requirements.
Objectives _____________________________________________________________________________________
The assignment will allow you to demonstrate and exhibit that you:
Can analyze requirements and design and implement a database that caters for those requirements Can conduct independent research as part of your requirements analysis Have understood the basic principles of database design and implementation and have applied them to your design
Scenario ___________________________________________________________________________________
Based on Temporary Employment’s(TE) ERD diagram you have been tasked with creating a database that will capture the basic structure given in the ERD. TE also require some reports for strategic decision making and improving efficiency of daily operations. To achieve this you are required to:
Use DDL to create the table structures and populate them.

PREREQUISITE COURSE PK,FK1 COURSE NUM PK COURSE NUM uires PK,FK2 QUAL CODE >O COURSE DESCRIPTION COURSE FEE FK1 QUAL CODE is required as QUALIFICATION generates COMPANY s taught in PK coMP CODE PK QUAL CODE QUAL DESCRIPTION COMP NAME S Wr en in SESSION PK SESSION NUM EDUCATION OPENING SESSION STARTDATE PK, FK1 QUAL CODE. SESSION FEE PK PK,FK2 CAND NUM FK 1 COURSE NUM OPENING DESCRIPTION EDUC DATE OPENING AVAILABLE FK1 COMP CODE FK2 QUAL CODE ns is fi CANDIDATE PK CAND NUM is placed in PLACEMENT CAND LNAME PK cretes combetes ENROLL PLACEMENT DATE OPENING NUM FK1 PK,FK1 SESSION NUM FK2 CAND NUM PK,FK2 CAND NUM PLACEMENT TOTALHOURS JOBHISTORY ENROLL DATE ENROLL FEE PAID PK JHLID. produces FK1 CAND NUM PLACEMENT NUM FK2

Explanation / Answer

Query 0:-

DDL Commands:-

The above Create DDL commands will create the tables in your database.

The below is the insert command which inserts data into your tables. Below is the syntax based on that insert values into your database.

Example:-- Insert into comapny values(12345,'chegg');

Query 1:-

Query 2:-

Query 3:-

Query 4:-

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.