Warning: Invalid argument supplied for foreach() in /srv/www/mhs/wp-content/themes/light-and-clouds-theme/functions.php on line 72
04210023 FREDDY RAKINAUNG

04210023 FREDDY RAKINAUNG

Just another Web Blog Mahasiswa Universitas Narotama Sites site



TUGAS UTS SISTEM BASIS DATA

April 26th, 2012
1.Dalam perusahaan ABC terdapat 5 entitas : line Item.Barang (Item),Sales Order,Customer,Sales Person

Line Item
1) Quantity (Attribute)
2) Extended Price (Attribute)
3) Sales Order Number (FK
to Sales Order Table)
4) Item Number (FK to Item
Table) (PK for Line Item)

Item
1) Item Number (PK)
2) Item Description (Attribute)
3) Unit Price (Attribute)

Sales Order
1) Sales Order Number (PK)
2) Date (Attribute)
3) Customer Name (FK to Customer table)
4) Sales Person Name (FK to Sales Person table)
5)SubTotal (Calculated Attribute)
6) Tax (Calculated Attribute)
7) Total (Calculated Attribute)

Customer
1) Customer Name (PK)
2) Address (Attribute)
3) City (Attribute)
4) State (Attribute)
5) Zip (Attribute)
6) Phone (Attribute)

Sales Person
1) SalesPersonName (PK)
2) SalesPersonCode (Attribute)

2.Berikut ERD  (Entity Relationship Diagram) dari perusahaan ABC :

KARDINALITAS :

1.LINE ITEM TO ITEM

kardinalitas : satu Item dapat digunakan dalam satu produk jalur yang berhubungan dengan pesanan penjualan berbeda tetapi satu line Iten hanya untuk satu Item

Despedensi : entitas Line Item dan Item saling behubungan.

2.SALES ORDER TO LINE ITEM

Kardinalitas : mungking ada bnyak line Item untuk satu Sales Order,satu line Item untuk satu Item

Despedensi : entitas Sales Order to Line Item tidak saling bergantung.

3.SALES PERSON TO SALES ORDER

Kardinalitas : salah satu penjualan orang bisa terlibat dengan sales order,tp satu sales Order hanya ditangani satu sales Person.

Despedensi : entitas Sales Order to Sales person saling bergantung.

4.CUSTOMER TO SALES ORDER

Kardinalitas : mungking ada banyak sales Order untuk satu customer tetapi sales Order hanya bisa untuk satu customer

Despedensi : entitas customer to sales order tidak saling bergantung.

TUGAS 2

March 16th, 2012

jawab soal no 8

<html>
<body>
<head>
<title>soal no 8 </title>
</head>
<table width ="300" border +"1" align="center">
<tr align="center">
	<td><b>NO</td></b>
	<td><b>NIM</td></b>
	<td><b>NAMA</b></td>
</tr>
<tr>
	<td align="center">1</td>
	<td>04210022</td>
	<td>Freddy</td>
</tr>
<tr bgcolor="yellow">
	<td align="center"><em>2</em></td>
	<td><em>04210023</em></td>
	<td><em>Freddy Rakinaung</em></td>
</tr>
<tr>
	<td align="center">3</td>
	<td>04210024</td>
	<td>Rakinaung</td>
</tr>
</table>
</body>
</html>

jawab soal no 9
<html>
<head>
<title>soal no 8 </title>
</head>
<body bgcolor="silver">
<table width ="300" border +"1" align="center">
<tr align="center">
	<td><b>NO</b></td>
	<td><b>NIM</b></td>
	<td><b>NAMA</b></td>
</tr>
<tr>
	<td align="center">1</td>
	<td>04210022</td>
	<td>Freddy</td>
</tr>
<tr bgcolor="yellow">
	<td align="center"><em>2</em></td>
	<td><em>04210023</em></td>
	<td><em>Freddy Rakinaung</em></td>
</tr>
<tr>
	<td align="center">3</td>
	<td>04210024</td>
	<td>Rakinaung</td>
</tr>

</table>
</body>
</html>

jawaban soal no 10
<html>
<body>
<head>
<title>soal no 9 </title>
</head>
<table width ="300" border +"1" align="center" bgcolor="yellow">
<tr align ="center">
 <td colspan="3"><b>KELOMPOK</b></td>

</tr>
<tr font color= "red">
	<td><font color="red">I</td>
	<td><font color="red">04210022</td>
	<td><font color="red">Freddy</td>
</tr>
<p>
</font>
<tr>
	<td rowspan="2">II</td>
	<td>04210023</td>
	<td>Freddy Rakinaung</td>
</tr>
<tr>
	<td>04210024</td>
	<td>Rakinaung</td>
</tr>
</table>
</body>
</html>

Hello world!

March 1st, 2012

Welcome to Web Blog Mahasiswa Universitas Narotama Sites. This is your first post. Edit or delete it, then start blogging!