Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Implementation (PHP)
04-02-2014, 11:57 AM,
Post: #1
Database Implementation (PHP)
Assalammualaikum semua,

Alhamdulillah yana masih lagi berpeluang untuk berkongsi bersama rakan2, abang2, kakak2, adik2 dan cikgu2 sekalian. Harini yana nak minta pendapat dari siapa2 yang mana dari belajar sendiri atau sedang mengambil lantas menyambung pembelajaran didalam bidang IT ni, yana rasa forum ni yang paling sesuai untuk kita berkomunikasi didalam bahasa melayu campur2 BM+BI pon ok...huhuhu...yana "post" adalah bertujuan berkongsi untuk kepada sesiapa ada berminat/berpeluang memberi idea/cara/tunjuk ajar serta mengenalpasti masaalah dan sebagainya. sekian terima kasih.

PURPOSE
The purpose of this assignment is to test your skills in developing a simple database using Database Management System (DBMS) and to apply the knowledge that you have learnt on manipulating queries.

REQUIREMENT / ASSIGNMENT QUESTION
A relational schema of a database is provided below, which is about Employees, the departments they work in, and the Projects they are working on.

EMPLOYEE (EmpID, EmpName, DoB, Address, Gender, Salary, SupervisorID, DeptNo)
DEPARTMENT (DeptNo, DeptName, ManagerID, ManagerStartDate)
DEPT_LOCATION (DeptNo, DeptLocation)
PROJECT (ProjNo, ProjName, ProjLocation, DeptNo)
WORKS_ON (EmpID, ProjNo, Hours)

[Note: Primary key is underlined, Foreign key is dotted underlined]

Use Microsoft Access to create the tables (using SQL) and enter sample data (using SQL or GUI with 5 records per table). Use suitable data type for each field and create the relationships between the tables. Then, write SQL queries that answer the questions below (one query per question) and run them:

1. Retrieve the names of employees in Finance Department who work more than 10 hours per week on the 'WangsaMaju2013' project.
2. For each project, list the project name and the total hours per week (by all employees) spent on that project.
3. Retrieve the names of employees who are not working on any project.
4. Find the names and addresses of employees who work on at least one project located in Wangsa Maju, whose department isn’t located in Wangsa Maju.
5. Find details of those employees whose salary is greater than the average salary for all employees in his/her department in ascending order of salary.

You should hand in a printout of:
1. Each query used to create the tables.
2. Each table which shows table name, fields and sample records.
3. The relationships between tables.
4. Each query in “SQL View”, so that the grader can see your SQL code.
5. The result of each query.

ermm...senang cerita macam mana nak start eh?
Someone like you LOL
Reply
04-02-2014, 12:14 PM, (This post was last modified: 04-02-2014, 12:15 PM by lamki.)
Post: #2
RE: Database Implementation (PHP)
mulakan dengan bismillah

Quote:ermm...senang cerita macam mana nak start eh?
Quote:Use Microsoft Access to create the tables (using SQL) and enter sample data (using SQL or GUI with 5 records per table). Use suitable data type for each field and create the relationships between the tables. Then, write SQL queries that answer the questions below (one query per question) and run them:

lepas tu buat dia punya query,
Revenge 101 :
Spoiler:

1.Pee in plate
2.Freeze the pee(in 1.)
3.Slide frozen 'pee disc' under the victim's door(room or house, any will do)
4.The pee disc will now melt.
5.???
6.Profit

Hmm
Reply
04-02-2014, 12:27 PM,
Post: #3
RE: Database Implementation (PHP)
erkkkkkk , aku pena buat ni masa foundation GayFace haahaaa

yana ni student mana ?
Can u See Me
Troll 2
Reply
04-02-2014, 06:27 PM,
Post: #4
RE: Database Implementation (PHP)
heheh...rahsia..yana share for reference tuk yg lain2..
Someone like you LOL
Reply
04-02-2014, 06:34 PM,
Post: #5
RE: Database Implementation (PHP)
lazy gurl mehh.. go study. make it yourself. ask when you are already start and face problem such logic and reasoning problem.
Reply
04-02-2014, 06:59 PM,
Post: #6
RE: Database Implementation (PHP)
thanks to @linear..i will take that word for my passion to do this assignment :-)
Someone like you LOL
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  [problem] insert to cannot add in data in database pron3t 4 532 14-07-2013, 11:00 PM
Last Post: PistolCodez
  2 database 1 sistem apitmanu 2 468 06-11-2012, 08:11 PM
Last Post: apitmanu
  [Help]code bring session data to database menba 2 585 30-09-2012, 06:28 PM
Last Post: Skiddies
  [Tutorial] Berapa Saiz Sesuai Bagi Elemen Dalam Database? s3m00t 0 790 20-01-2012, 02:41 AM
Last Post: s3m00t
  [help]update database for pass salt pron3t 3 602 24-12-2011, 10:12 AM
Last Post: ak47suk1
  [help]about database php pron3t 2 551 03-12-2011, 10:24 PM
Last Post: ak47suk1
  ask php connect to database pron3t 25 4,712 30-11-2011, 12:47 PM
Last Post: dede
  Prob . . database mysql tak connect AceyrafRoshlanz 7 987 22-11-2011, 05:54 PM
Last Post: AceyrafRoshlanz

Forum Jump: