# data[].attributes.headline
แปะได้เลยเด้ออ

# data[].attributes.subject
แปะได้เลยเด้ออ

# data[].attributes.body
ส่งเป็นรูป พารากราฟ อะไรก้ได้เลยยย~

# data[].attributes.body
Entity

พัสดุ

ใช้แล้วหมดไป

ใช้แล้วไม่หมดไป

คนยืม

พนักงาน

องค์กร

บุคคลภายนอก

Relationship

คนยืมยืมพัสดุ

พนักงานเบิกพัสดุ

Attribute

พัสดุ

itemID

itemName

itemAmount

itemType

itemDepartment

คนยืม

borrowerName

borrowerID

borrowerType

Employee

empID

empBirthDay

empAddress

empTel

empMail

emp

Organization

orgIndex

External

เดะมานึกต่อ

# data[].attributes.body
Product[

-PID

-Price

-Name

-Amount

-Department

]

User[

-UID

-Name

-Address

-TelNo

]

Employee[

-EID

-EName

-Address

-TellNO.

-Department

]

Relationship[

User borrow Product

-borrowDate

-returnDate

-penalty

Employee manage Product

]

Employee can add/remove Product from the same Department to the database

Employee can change the Amount of Product from the same Department in the database

Employee from other Department can borrow other Department

User/Employee can borrow more than 1 Product

Product belong to only 1 department

Product that already been borrowed can't be borrow until the Product is return

# data[].attributes.body
Entity & Attributes

1. Employee

EName (FName, LName)

EID [PK]

Address (City, State, ZipCode)

ETelNo

Email

EBirthdate

SSN

EPosition

ESalary

ESex

EmployeeType (full-time, part-time, Inturn)

2. Item

IID [PK]

IName

IPrice

PurchaseDate

ILocation (มาจาก department ไหน)

LastMaintenanceDate

WarrantyExpirationDate

3. Department

DNo [PK]

DName

DLocation

Relationships

1. Borrow(Relationship between Employee and Item)

BorrowDate

ReturnDate

Status(Pending, Returned)

Employee can borrow more than 1 item.

Item is borrowed by only 1 employee.

2. Is_In (Relationship between Employee and Department)

Employee belong to only 1 department.

Department have more than 1 employee.

3. Have (Department have items)

Department can have more than 1 items.

Item belong to only 1 department.

# data[].attributes.body
Item

-ItemID

-Name

-Type

-PurchaseDate

-Amount

-Price

-Department

-NumberOfUsage

User

-Name

-LastName

-Type

-Internal

-InternalUserID

-Department

-PhoneNumber

-External

-IdentificationID

-Address

-PhoneNumber

Department

-Name

-InternalUserAmount

-Item

Relationships

[User borrow Item]

-BorrowDate

-Amount

-DueDate

-HaveReturn(True,False)

[User re-stock Item]

(Only InternalUser can re-stock Item)

-Item

-Amount

-Price

-Department

-Re-stockDate

[User in Department]

(Only InternalUser can be in Department)

-InternalUser can be in only one Department

-Department can have many InternalUser

[Item in Department]

-Item can be in many Department

-Department can have many Item

# data[].attributes.body
Entity and Attribute :

Device

deID [PK]

Name

Type

NumOfDevice

PurchaseDate

PurchasePrice

Status

User ภายใน

inID [PK]

Fname

Lname

Phone

Email

User ภายนอก

outID [PK]

Fname

Lname

Phone

Email

Department

dNo [PK]

dname

Relationship :

1. User borrow Device

bStartDate

bEndDate

bQuantity

2. User add Device

aDate

aQuantity

3. User within Department

--------------------------------------------