Research Project Part 1
Research Project: Create Expense Table Assignment
Liberty University
Database Design and Development
CSIS 525-D01
Professor Terry House
July 18, 2024
ER Diagram
%
Bil
File
Edit
View
Insert
Mode
Window
Help
Deh
Bex
some
A@
R+
Vv
2a
Users
Expenseltem
Userilo
UserFirstName
UserLastName
UserPhone
UserEmail
Asset
UserOratio
asset
Oh
SssetDes
Orgunit
‘raw
Budgetitem
‘OrgName
r
io
ilo
OrgParent
ile
mn
Blame
Actual
ECNo
OraNo
EcName
ECNo.
ECLimit
Database and table creation
Ete
eae
1]
CREATE
DATABASE
ExpenseCSIS325
2)
GO;
3
4)
USE
ExpenseCS1s325
5)
GOs
6
7
8
o]}acreate table
Expcat
(
10)
11]
FCNo
int
check(FCNo
>=@)
not
null
primary
key,
12)
EcName
varchar(255)
not
null,
13]
ECLimit
decimal(1@,2)
not
null
default
0.6
1a
Ls
15)
16)
17)
aCreate
table
Asset
(
18)
19]
AssetNo
int
check(AssetNo
>=@) not
null
primary
key,
20)
AssetDesc
varchar(255)
not
null,
aif
|);
22|
23)
24)
aCreate
table
Orgunit
(
25)
26]
OrgNo
int
not
null
check(OrgNo
>=@)
primary
key,
27\|
OrgName
varchar(S@)
not
null,
28]
OrgParentNo
int
check(O>gParentNo
>=@)
294
|);
30)
31)
32)
aCreate
table
Users
(
33|
34)
UserNo
int not
null
primary
key
check
(UserNo
>=
@),
35]
UserFirstName
varchar(5@)
not null,
36)
UserLastName
varchar(5@)
not null,
37)
UserPhone
varchar(2@)
not null,
38]
User€mail
verchar(5@)
not
null
unique,
39)
UserOrgNo
int
check
(UserOrgNo
@)
foreign
key
(UserOrgNo)
references
Orgunit(OrgNo),
40|
Constraint validémail
Check
(User€mail like'%@%')
109%
EMF
Messages
Commands
completed
successfully.
Completion
time:
2024-07-17T17:59:47.3872122-04:00
109%
ere
een
eC)
d3
42
43/ciCreate
table
ExpenseReport
(
44
45]
ERNo
int not
null
primary
key
check
(ERNo
>=
@),
46)
ERDesc
varchar(255)
not null,
47)
ERSubmitDate
datetime
not
null
default
(getdete()),
4g]
ERStatusDate
datetime
not
null
default
(getdate()),
49)
ERStatus
varchar(255)
not
null
default
‘PENDING’,
50]
SubmitUserNo
int not
null
check
(SubmitUserNo
>-@)
foreign
key
(SubmitUserNo)
references
Users(UserNo)
on
delete
cascade
on update
cascade,
51]
AppruserNo
int
check
(ApprUserNo
>=)
fcreign
key
(ApprUserNo)
references
Users(UserNo)
01
delete
cascade
on
update
cascade,
52)
Constraint
Estatus
Check(ERStatus
in
(‘PENDING’,
"APPROVED", ‘DENIED')),
53)
Constraint
ESDate
Check(ERStatusDate
ERSubmitDate),
54)|
Constraint
AppUsr
Check(ERStatus
=
‘Pending’
or
ApprUserNo
is
not
null)
55]
|)s
56)
57)
aCreate
table
BudgetItem
(
58)
59]
BINo
int
check(BINo
>=@) not
null
primary
key,
60]
|BIVear
int
not
null,
61)
BIAmt
decimal(1@,2)
not
null
default
0.€,
62)
BIActual
decimal(1@,2)
not
null
default
@.0,
63]
OrgNo
int
check(OrgNo
>=@)
foreign
key(CrgNo)
references
OrgUnit(OrgNo)
on
delete
cascade
on
update
cascade,
64]
ECNo
int
check(ECNo
>=@)
foreign
key(ECNo)
references
ExpCat(ECNo)
on
delete
cascade
on
usdate
cascade,
65]
Constraint
BI_KEY
unique
(BIYear,
OrgNo, ECNo),
66)
Constraint
BI_Year
Check
(BIYear
>1980)
679
)5
68.
69]
=iCreate
table
ExpenseItem
(
70)
71)
EINo
int
primary
key
not
null
check
(EINO
>=8),
72)
ExpDesc
Varchar(255)
not
null
.
73)
ExpenseDate
datetime
not
null
default(getdate()),
74)
Expamt
decimal(1@,2)
not
null
default
0.0,
75)
ExpAppramt
decimal(1@,2)
not
null
default
0.0
.
76)
ERNo
int
check(ERNo
>=@) not
null
foreign
key(ERNo)
references
ExpenseReport(ERNo)
on
delete
cascade
on
update
cascade,
77|
ECNo
int
check(ECNo
>=@) not
null
foreign
key(ECNo)
references
ExpCat(ECNo)
on
delete
cascade
on
update
cascade,
78]
AssetNo
int
check(AssetNo
>=@)
foreign
key(AssetNo)
references
Asset(AssetNo)
on delete
cascade
on
update
cascade,
79)
Constraint
Appamt
Check(ExpAppramt
<=
ExpAmt)
sep
)s
109%
+
EMF
Messages
Commands
completed
successfully.
Completion
time:
2024-07-1717:5:
109%
1
GJINSERT
INTO
Asset
2
(AssetNo,
AssetDesc)
3
VALUES
(1,
"Company
Car");
4
5
GlINSERT
INTO
Asset
6
(AssetNo,
AssetDesc)
7
VALUES
(2,
"Company
Jet’);
8
9
SINSERT
INTO
Asset
10
(AssetNo,
AssetDesc)
11
VALUES
(3,
"Company
Van");
12
13
GINSERT
INTO
Asset
14
(AssetNo,
AssetDesc)
15,
VALUES
(4,
"Company Truck");
16
17
GINSERT
INTO
Orgunit
18.
(OrgNo,
OrgName,
OrgParentNo)
19)
VALUES
(1,
"Accounting",
NULL
);
20
24
SINSERT
INTO
Orgunit
22.
(OrgNo,
OrgName,
OrgParentNo)
23,
VALUES
(2,
"Sales",
NULL);
24
25
SJINSERT
INTO
Orgunit
26
(OrgNo,
OrgName,
OrgParentNo)
27
VALUES
(3,°IT',
NULL);
28,
29
SJINSERT
INTO
Orgunit
30
(OrgNo,
OrgName,
OrgParentNo)
31.
VALUES
(4,°IT
Development’
,3);
32,
109%
.
BI
Messages:
ow
affected)
ow
affected)
(2
row
affected)
ow
affected)
(2
row
affected)
Completion
time: 2024-07-17T18:!
106.9279266-04:99
109%
=
Insert Statements
Eater
GJINSERT
INTO
Orgunit
(Orgilo,
OrgName,
OrgParentho)
VALUES
(5,
"Accounts
Receivable’
,1);
GJINSERT
INTO
Orgunit
(Orgilo,
OrgName,
OrgParentio)
VALUES
(6,
"IT
Support’
,3);
GJINSERT
INTO
Orgunit
(Orgilo,
OrgName,
OrgParentio)
VALUES
(7,
"Accounts
Payable’
,4);
CJINSERT
INTO
ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(1,
‘Dinner’
,58.0@);
CJINSERT
INTO
ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(2,'Car
Rental’
,100.0@);
CJINSERT
INTO
ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(3,
"Breakfast"
,25.0@)
;
GJINSERT
INTO
ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(4,
"Local
Transportation’
,160.@0)
;
GJINSERT
INTO
ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(5,
Airfare’
,5000.0@)
;
(2
zou
atsected)
(2
zou
atsected)
(2
zou
atsected)
(2
zou
atsected)
(2
zou
atsected)
Completion
time:
2024-07-17T18:00:06.9279166-04:00
09%
Cancel
Executing
Query
(Alt
Break)
ieee
ee
aan
GJINSERT
INTO ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(6,
‘Lunch’
25.08);
GJINSERT
INTO ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(7,
"Lodging"
300.60)
;
GJINSERT
INTO ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(8,
"Admission
Fee’
,2008.08)
;
GJINSERT
INTO ExpCat
(ECNo,
ECName,
ECLimit)
VALUES
(9,
'Gas’,35.60);
CJINSERT
INTO
Users
(Userlio,
UserFirstName,
UserLastliame,
UserPhone, UserEmail,
UserOrglo)
VALUES
(1,
"Sue",
"Herdon","(2@5)
339-3312",
"sherdongorg.com’,3);
CJINSERT
INTO
Users
(Userlio,
UserFirstName,
UserLastliame,
UserPhone, UserEmail,
UserOrglo)
VALUES
(2,
"Bill",
"Jones",
"(3@3)
265-8833",
,6);
GJINSERT
INTO
Users
(Userlio,
UserFirstName,
UserLastliame,
UserPhone, UserEmail,
UserOrglo)
VALUES
(3,
"Joe",
"Smith",
*(303)
443-9943",
'
,4);
GJINSERT
INTO
Users
(Userlio,
UserFirstName,
UserLastliame,
UserPhone, UserEmail,
UserOrglo)
VALUES
(4,
William’,
"Freed"
,"(303)
445-3355",
,1);
row
affected)
row
affected)
row
affected)
(0
row
affected)
(a
row
affected)
Completion
time:
2024-07-17T18:00:06.9279166-04:00
09%
a
a
109%
Completion
time:
2024-07-17T18:00:06.9279166-0;
SQL
Query2.sql-
not
connected*
eae
eae
aN)
(Userlio,
UserFirstName,
UserLastliame,
UserPhone, Userémail,
UserOrgNo)
VALUES
(4,
William’
,
‘Freed’
,"
(303)
445-3355",
‘[email protected]’,1);
SJINSERT
INTO
Users
(Useriio,
UserFirstilame,
UserLastllame,
UserPhone,
Usermail,
UserOrgNo)
VALUES
(5,"Sara’,
‘Jonson’,
*(3@3)
445-3321",
,7);
=JINSERT
INTO
Users
(Userlio,
UserFirstName,
UserLastllame,
UserPhone, Userémail,
UserOrgNo)
VALUES
(6,
‘Tom’,
"Sanchez',,*(3@3)
445-3322"
,
‘[email protected]’,5);
=JINSERT
INTO
Users
(Userlio,
UserFirstName,
UserLastllame,
UserPhone, Userémail,
UserOrgNo)
VALUES
(7,"Marry”,
"Blake’,*(3@3)
445-3333",
,2);
=JINSERT
INTO
ExpenseReport
(ERNo,
ERDesc,
ERSubmitDate,
ERStatusDate,
ERStatus,
SubmitUserNo,
ApprUSerNo)
VALUES
(1,
‘Sales
Presentation’
,
8/10/2606
,
"8/26/2006",
"APPROVED'
,3,4);
=JINSERT
INTO
ExpenseReport
(ERNo,
ERDesc,
ERSubmitDate,
ERStatusDate,
ERStatus,
SubmitUserNo,
ApprUSerNo)
VALUES
(2,
‘Conference’
"8/16/2006"
,
"8/17/2006"
,
"APPROVED"
4,4);
GJINSERT
INTO
ExpenseReport
(ERNo,
ERDesc,
ERSubmitDate,
ERStatusDate,
ERStatus,
SubmitUserNo,
ApprUSerNo)
VALUES
(3,
‘Training
Course’
,
"9/23/2006"
"9/25/2806"
,
APPROVED’
,2,1);
GJINSERT
INTO
ExpenseReport
(ERNo,
ERDesc,
ERSubmitDate,
ERStatusDate,
ERStatus,
SubmitUserNo,
ApprUSerNo)
VALUES
(4,"IT
Group
Lunch’
,"9/29/2006'
,
"9/29/2006"
,
APPROVED’
,1,4);
SINSERT
INTO
ExpenseReport
affected)
affected)
affected)
affected)
ow
affected)
200
Rare
Pea
SC
CJINSERT
INTO
ExpenseReport
(ERNo,
ERDesc,
ERSubmitDate,
ERStatusDate,
ERStatus,
SubmitUserNo,
ApprUSerNo)
VALUES
(4,°IT
Group
Lunch’
,
"9/29/2006"
,"9/29/2006"
,
"APPROVED"
,1,4);
SJINSERT
INTO
ExpenseReport
(ERNo,
ERDesc,
ERSubmitDate,
ERStatusDate,
ERStatus,
SubmitUserNo,
ApprUSerNo)
VALUES
(5,
"Sales
Presentation’
,
"9/38/2006"
,
"10/1/2006",
"APPROVED',7,4);
GJINSERT
INTO
ExpenseItem
(EIN,
ExpDesc,
ExpenseDate,Expamt,
ExpAppramt,
ERNo, ECNo,
AssetNo)
VALUES
(1,
"Car’,
"8/9/2006"
,150.00,[email protected],1,7,NULL);
=JINSERT
INTO
ExpenseItem
(EIN,
ExpDesc,
ExpenseDate,ExpAmt,
ExpAppramt,
ERNo, ECNo,
AssetNo)
VALUES
(2,
Hilton’,
“8/9/2006'
,99.00,99.00,1,7,
NULL);
=JINSERT
INTO
ExpenseItem
(EIN,
ExpDesc,
ExpenseDate,ExpAmt,
ExpAppramt,
ERNo, ECNo,
AssetNo)
VALUES(3,
"Gas'
,"8/9/2006',35.@0,20.00,1,9,1);
=JINSERT
INTO
ExpenseItem
(EIN,
ExpDesc,
ExpenseDate,ExpAmt,
ExpAppramt,
ERNo, ECNo,
AssetNo)
VALUES(4,
"Breakfast
’,
"8/10/2006"
,10.00,10.00,1,3,NULL);
=JINSERT
INTO
ExpenseItem
(EIN,
ExpDesc,
ExpenseDate,ExpAmt,
ExpAppramt,
ERNo, ECNo,
AssetNo)
VALUES(5,
‘Comfort
Inn”,
"8/16/2006"
,225.@0,225.00,2,7,
NULL);
=JINSERT
INTO
ExpenseItem
(EIN,
ExpDesc,
ExpenseDate,ExpAmt,
ExpAppramt,
ERNo, ECNo,
AssetNo)
VALUES(6,
"Airfare’,
“8/13/2006"
,325.00,325.00,2,5,NULL);
affected)
affected)
affected)
affected)
ow
affected)
Completion
time:
2024-07-17T18:00:06.9279166-04:00
09%
ieee
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.ExpAmt,
ExpAppramt,
ERNo, ECNo,
VALUES(6,
"Airfare’,
"8/13/2006"
,
325.00,325.@0,2,5,NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.ExpAmt,
ExpAppramt,
ERNo, ECNo,
VALUES(7,
Dinner’,
"8/15/2006"
,23.94,23.94,2,1,
NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.ExpAmt,
ExpAppramt,
ERNo, ECNo,
VALUES(8,
‘Dinner’,
"8/14/2006"
,32.50,32.50,2,1,NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.ExpAmt,
ExpAppramt,
ERNo, ECNo,
VALUES(9,
‘Dinner’,
"8/13/2006"
,19.64,19.64,2,1,
NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate,ExpAmt,
ExpAppramt,
ERNo, ECNo,
VALUES(18,
‘Lunch’,
"8/15/2006"
,25.@0,25.@0,2,6,NULL);
|JINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate,
ExpAmt,
ExpAppramt,
ERNo, ECNo,
VALUES(14,
‘Breakfast’,
'8/15/2006',10.32,18.32,2,3,NULL);
INSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.ExpAmt,
ExpAppramt,
ERNo, ECNo,
VALUES(12,
‘Motel
6",
°9/23/2006"
,57.95,57.95,3,7,NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.ExpAmt,
ExpAppramt,
ERNo, ECNo,
VALUES
(13,
'Gas"
,
"9/23/2086"
,15.94,15.94,3,9,3);
row
affected)
row
affected)
row
affected)
(a
row
affected)
(2
row
affected)
Completion
time:
2024-07-17T18:00:06.9279166-04:00
09%
~
Wee
Assetio)
Assetio)
Assetio)
Assetio)
Assetio)
Assetio)
Assetio)
Assetio)
SSC)
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.Expamt,
ExpAppramt,
ERNo,
ECNo,
AssetNo)
VALUES(7,
‘Dinner’,
"8/15/2006"
,23.94,23.94,2,1,NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.Expamt,
ExpAppramt,
ERNo,
ECNo,
AssetNo)
VALUES(8,
‘Dinner’,
"8/14/2006"
,32.50,32.50,2,1,NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.Expamt,
ExpAppramt,
ERNo,
ECNo,
AssetNo)
VALUES(9,
“Dinner”
,
"8/13/2006"
,19.64,19.64,2,1,NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate,Expamt,
ExpAppramt,
ERNo,
ECNo,
AssetNo)
VALUES(1@,
‘Lunch’
,
"8/15/2006"
,25.00,25.00,2,6,NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.Expamt,
ExpAppramt,
ERNo,
ECNo,
AssetNo)
VALUES(11,
"Breakfast,
°8/15/2006'
,10.32,10.32,2,3,NULL);
GJINSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.Expamt,
ExpAppramt,
ERNo,
ECNo,
AssetNo)
VALUES(12,
“Motel
6",
°9/23/2006"
,57.95,57.95,3,7,NULL);
INSERT
INTO
ExpenseItem
(EINo,
ExpDesc,
ExpenseDate.Expamt,
ExpAppramt,
ERNo,
ECNo,
AssetNo)
VALUES(13,
"Gas",
"9/23/2086"
,15.94,15.94,3,9,3);
GJINSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(1,2006,1,1,4000.00,76.08)
;
affected)
affected)
affected)
affected)
row
affected)
Completion
time:
2024-07-17T18:00:06.9279166-04:
09%
~
fies
INSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(1,2086,1,1,4000.00,76.08)
;
GJINSCRT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(2,2086,1,2,3000.00,0.@0)
;
INSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(3,2086,1,3,2000.00,
10.32);
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES (4,2006,1,4,500.00,0.@0)
;
GJINSERT INTO
BudgetItem
(Billo,
BIVear,
Orgo,
ECNo,
BIAmt,
BIActual)
VALUES
(5,2086,1,5,10800.00,
325.00);
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(6,2086,1,6,2080.00,
25.20);
GJINSERT INTO
BudgetItem
(BIllo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(7,2086,1,7,1000.00,
225.00)
;
INSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(8,2086,1,8,6000.00,0.@0)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(9,2086,1,9,5000.00,0.@0)
;
INSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(10,2606,2,1,
16000.
00,167.@0)
;
affected)
affected)
affected)
affected)
ow
affected)
Completion
time:
2024-07-17T18:00:06.9279166-04:
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(10,2606,2,1,16000.0,167.@0)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(11,266,2,2,7520.00,98.00)
;
INSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(12,2606,2,3,4800.00,10.75)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(13,2006,2,4,1500.08,5.50)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(14,266,2,5,15800.00,650.@0)
;
CJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(15,206,2,6,500.08,6.79);
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(16,2606,2,7,12000.00,0.08)
;
INSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(17,2006,2,8,7580.08,0.20)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(18,
206,2,9,7580.08,0.20)
;
INSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(19,2606,3,1,400.08,0.00)
;
CJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
affected)
affected)
affected)
affected)
ow
affected)
Completion
time:
2024-07-17T18:01
16.
9279166-94:00
Midter
te
ies
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgio,
ECNo, BIAmt,
BIActual)
VALUES
(20,2086,
3,2,300.00,0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgiio,
ECNo, BIAmt,
BIActual)
VALUES
(21,2006,3,3,2080.00,0.00)
;
INSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgilo,
ECNo, BIAmt,
BIActual)
VALUES
(22,2086,3,4,500.00,24.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgiio,
ECNo, BIAmt,
BIActual)
VALUES
(23,2086,3,5,10000.00,0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgio,
ECNo, BIAmt,
BIActual)
VALUES
(24,2006,
3,6,2000.08,75.08)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgio,
ECNo, BIAmt,
BIActual)
VALUES
(25,2086,
3,7,10000.00,0.08)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgio,
ECNo, BIAmt,
BIActual)
VALUES
(26,2086,
3,8,10000.00,0.00);
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgiio,
ECNo, BIAmt,
BIActual)
VALUES
(27,2086,3,9,5080.00,0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgio,
ECNo, BIAmt,
BIActual)
VALUES
(28,2006,
4,1,150.00,0.00)
;
GJINSERT
INTO
BudgetItem
(BINv,
BIYear,
Orglo,
ECNo, BIAML,
BIACLual)
VALUES
(29,2086,
4,2,1200.00,0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
Orgio,
ECNo, BIAmt,
BIActual)
row
affected)
row
affected)
row
affected)
(2
cow
afrected)
(2
row
affected)
Completion
time:
2024-07-17T18:00:06.9279166-04:00
09%
Midterm,
CJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(29,2606,
4,2,1200.08,0.00)
;
INSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(30,
2686,4,3,
1880.00.
1€.02)
;
INSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(31,2606,4,4,250.00,0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(32,2606,4,5,400.08,0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(33,2606,4,6,1500.08,0.00)
;
CJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(34,2606,4,7,2600.00,99.08)
;
INSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(35,2606,4,8,800.08,0.00)
;
CJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(36,2606,4,9,650.00,35.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(37,2606,5,1,1500.08,0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(38,2606,5,2,1200.08,0.00)
;
CJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
affected)
affected)
affected)
(a
row
affected)
(1
row
affected)
Completion
time:
2024-07-17T18:00:06.9279166-0.
00
09%
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(39,2006,5,3,1000.00,0.00);
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(40,
2006,5,4,250.00,0.00);
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(41,2006,5,5,4000.00,0.20)
;
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(42,2006,5,6,1500.00,0.2@)
;
SjINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(43,2006,5,7,2000.00,0.0@);
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(44,2006,5,8,5500.00,0.00);
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(45,2006,5,9,350.00,0.00);
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(46,2006,6,1,1500.00,0.20);
INSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(47,2006,6,2,1200.00,0.2@)
;
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
VALUES
(48,2006,6,3,1000.00,2.99);
SJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
affected)
affected)
affected)
(a
row
affected)
(2
row
affected)
09%
BrActual)
BrActual)
BrActual)
BrActual)
BrActual)
BrActual)
BrActual)
BrActual)
BrActual)
BrActual)
BrActual)
Completion
time:
2024-07-17T18:00:06.9279166-04:00
iw
i
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(49,
206,6,4,250.00,0.00)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VAIUIFS
(5@,2006,
6,5,
4800.Aa,0.08):
INSERT
INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(51,2006,
6,6,1500.0,5.95)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(52,2006,
6,7,2600.0,57.95)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(53,2606,6,8,
5500.0,
1000.@0)
;
CJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(54,2006,6,9,350.00,
15.94)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(55,2006,7,1,1580.0,0.00)
;
CJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(56,266,7,2,1200.00,0.00)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(57,2606,
7,3,1000.0,0.00)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(58,2006,7,4,250.00,0.@0)
;
GJINSERT INTO
BudgetItem
(BINo,
BIVear,
OrgNo,
ECNo,
BIAmt,
BIActual)
affected)
affected)
affected)
affected)
ow
affected)
Completion
time:
2024-07-17T18:00:06.9279166-04:00
109%
=
DROP
DROP
DROP
DROP
DROP
DROP
DROP
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
Completion
time:
SEQUENCE
SEQUENCE
SEQUENCE
SEQUENCE
SEQUENCE
SEQUENCE
SEQUENCE
(1
row
affected)
(1
row
affected)
Dieser
ea
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(59,2006,7,5,400.08,0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(60,2086,
7,6,[email protected],0.28)
;
INSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(61,2006,7,7,2000.08.0.20)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(62,2006,7,8,8000.00.0.00)
;
GJINSERT
INTO
BudgetItem
(BINo,
BIYear,
OrgNo,
ECNo,
BIAmt,
BIActual)
VALUES
(63,2006,7,9,650.00,0.00)
;
SEQUENCE
asset_seq
START
WITH
100
INCREMENT
BY
1;
SEQUENCE
orgunit_seq
START
WITH
1@@
INCREMENT
BY
1;
SEQUENCE
expcat_seq
START
WITH
10@
INCREMENT
BY
SEQUENCE
users_seq
START
WITH
100
INCREMENT
BY
1;
SEQUENCE
expensereport_seq
START
WITH
10@ INCREMENT
BY
1;
SEQUENCE
expenseitem_seq
START
WITH
100
INCREMENT
BY
1;
SEQUENCE
budgetitem_seq
START
WITH
100
INCREMENT
BY
1;
expenseitem_seq;
expensereport_seqs
users_seq:
asset_seq:
orgunit_seq:
expcat_seq:
budgetitem_seq:
2024-07-17918:
00:
06.9279166-04:00
109%
FE
Resute
gl
Messages
Name
Owner
Type
‘Asset
dbo
usertable
Created_datetime
2024-07-17
22:42:49,517
Column_name
Type
Computed
Length
Prec
Scale
Nullable
ThimTralingBlanks
FixedLenNulinSource
Collation
esetNo
int
“ResetDese
varchar
no
4
an)
255 70
(a)
NULL
(a)
‘SQL_Latin1_General_CP1_Cl_AS
Identity
‘Seed
Increment
Not
For
Replication
‘No
identity
column
defined.
NULL
NULL NULL
RowGuidCol
‘No
rowguidcol
column
defined.
Data
located_on_flegroup
PRIMARY
index
_name
‘ndex_descrption
index
keys
PK_Asset_434A45B829E610CC
clustered,
unique,
primary
key
located
on
PRIMARY
AssetNo
‘constraint
type
‘constraint_name
‘delete_action
update
action
status_enabled
status
for_repication
constraint_
keys
1
[CHECKCon
column
AsseiNio”
CK_Asset_AssetNNo_72C60C4A
(n/a)
(a)
Enabled
|s_For
Replication
_((AssetNo}>=0))
2
“PRIMARY
KEY
(clustered)
PK_Asset_434A45B829E610CC
(n/a)
(wa)
(nia) (nia)
AssetNNo
‘Table
is
referenced
by
foreign
key
[[BroenseCSi8326
dbo
Expensetem:
FK_Expencel_A.
1
[BINe
|
int
no
4
0
0
10
bie)
be)
NULL
2
BlYear
‘int
no
4 10
oO
no
n/a) (va)
‘NULL
3
BlAmt
decimal
no
9 mw
2
no
(a)
(va)
NULL,
4
BlActual
decimal
no
9 10
2
no
(n/a)
va)
‘NULL
5
OrgNo
‘int
no
4 10
oO
yes:
n/a) (va)
‘NULL
6
ECNo
ito
4
1
0
yes
hia)
(2)
NULL
Identity
Seed
Increment
Not
For
Replication
1
[Ne
identiy
column
defined.
NULL NULL
NULL
RowGuidCol
1
No
rowguideol
column
defined
Data_located_on_filegroup
1
L
PRIMARY
index_name
index_description
index_keys
1
BILKEY
monclustered,
unique,
unique
key
located
on
PRIMA...
BlYear,
OngNo,
ECNo
2
PK__Budgetht__3B3E03B95C0573D5
i
‘clustered,
unique.
primary
key
located
on
PRIMARY
BINo
constraint_type
constraint_name
delete_action
update_action
status_enabled
—status_for_replication
_constraint_keys.
1
UNIQUE
(non-clustered)
?
BI_KEY
na) va)
(va) (va)
BlYear,
OrgNo,
ECNo
2
CHECK
on
column
BlYear
BI_Year
(ray
ay
Enabled
Is
For_Replication
_((BI'’ear]}>(1900))
3
CHECK
on
column
OrgNo
CK
__Budaetlt....
(n/a)
a)
Enabled
|s_For_Replication
(OrgNo}>=(0))
4
CHECK
on
column
BINo
CK_Budgetit...
(n/a)
va)
Enabled
Is_For_Replication
(BINo}>=(0))
5
CHECKon
column
ECNo
CK_Budgett..
(n/a)
(va)
Enabled
Is
For
Replication
(ECNo}>=(0))
6
DEFAULT
on
column
BI...
DF__Budgetk..
(n/a)
a)
(n/a)
ve)
(0)
7
DEFAULT
on
column
BI...
DF__Budgeth..
(n/a)
va)
(va) (va)
(0.0)
8
FOREIGN
KEY
FK_Budgett..
Cascade Cascade
Enabled
|e
For
Replication
OrgNo
3
REFERENCES
Exp.
10
FOREIGN
KEY
FK_Budgetit...
Cascade:
Cascade
Enabled
Is_For_Replication
ECNo:
n
REFERENCES
Exp
12
PRIMARY
KEY
(clustered)
PK__Budgettt...
(n/a)
a) a)
va)
BINo:
sp_help definitions
EE
Results
gil
Messages
Name
Owner
Type
Created_datetime
1
[ExpCat
|
dbo
usertable
2024-07-17
2242.49 513
Column_name
Type
Computed
Length
Prec
Scale
Nullable
TrimTralingBlanks
FixedLenNullnSource
Collation
1
[Eco
rt
no 4
1
0 mm
tha)
ve)
NULL
2 “EtName
varchar
no 255
rn
0
‘SQL_Latnt
General
CP1_CLAS
3
ECLiit
decimal
no 9
1
2 mm
tha)
ve)
NULL
‘dentiy
Seed
Increment
Not
For
Replication
1
[Reidentty
column
defined.
|
NULL NULL NULL
owGuidCol
1
[Norewgudcol
column
defined
Data_located_on_fiegroup
1
[PRIMARY
index
ame
index_
description
index
keys
1
[PK
TEspCat
27336
1D3EBS2AF22
clustered,
unique.
primary
key
located
on
PRIMARY
ECNo
constraint
_type
-constraint_name
delete_action
update_action
status_enabled
status
_for_replication
_constraint_keys
1
(CHECKon
column
ECNo
|
CK_ExpCat_ECNo_6EFS7B66
n/a)
va)
Enabled
|s_For_Replication
((ECNo}>=(0))
2
DEFAULTon
column
ECLimt
DF_ExpCat_ECLimt_6FES9FIF
(n/a)
ve)
a)
ve)
CO)
3 PRIMARY
KEY
(clustered)
‘PK__ExpCat__2733E1D3E852AF22
(n/a) (n/a) (n/a) (n/a)
ECNo
Table
is
referenced
by
foreign
key
1
[[ExpenseCSi8325
dbo.
Budgetitem:
FKBudgettem
EC.
2
“BxpenseCSi5325.cbo
Expenseiem:
FK_Expensete_E.
FH
Results
gil
Messages
Name
Owner
Type
Created_datetime
([Eipenseltem’
dbo
usertable
2024-07-17
22:42:49
523
Colunnname
Type
Computed
Length
Prec
Scale
Nulable
TimTreingBlanks
FedLenNulnSource
Colation
[EINe
rt
m0 4
10
0 mm
hia)
ve)
NULL
BipDess
varchar
no 255
nono
0
SQL_Latint_General_CP1_CLAS
EipenseDate
datetime
no 8 ro
Wa) ve)
NULL
SpA
decimal
no 9
0
2m
tha)
ve)
NULL
ExpAprémt
decimal
no 9
1
2m
hia)
ve)
NULL
ERNo
rt
mm 4
10
0m
hia)
ve)
NULL
ECNo
rt
mm 4
10
0m
hia)
ve)
NULL
AcetNo
ito
4
10
0
yes
va) ve)
NULL
‘denty
Seed
Increment
Not
For
Replication
[Ne
dey
Coe
defied
|
NULL NULL NULL
owGuidCol
[ic
renguidcol
column
defined.
|
Data
_ocated_on_flegroup
(PRIMARY
|
index
pame
index_
description
index
keys
(Pk
ipensel
2281
1B5C12375F9
|
clustered,
unique,
primary
key
located
on
PRIMARY
—EINo
cconstraint_type
‘constraint_name
<delets_action
update
action
status
enabled
status
for
replication
constant
keys
(CHECK
Table
Level
|
AepAmt
(el
(wa)
Enabled
|s_For
Replication
(ExpApprAmt]<=[ExpAmt)
“CHECK
on
column
AssetNo
CK_Expensett_Asset_1EMBE88
n/a)
(wa)
Enabled
|s_For
Replication
_((AssetNo}>=/0))
CHECK
on
column
ECNo
CK_Expensete_ECNo_ICBC4616
(n/a)
a)
Enabled
|
For
Replication
(ECNe)>=(0)
CHECK
on
column
EINo
CK_Expensete_FINo_17036CCO
n/a}
a)
Enabled
|
For
Replication
(EINo}>=(0)
‘CHECK
on
column
ERNo
CK_Expensete_ERNo_1AD3FD...
(n/a)
a)
Enabled
|
For
Replication
(ERNo}>=(0)
DEFAULT
on
column
Exp...
DF_Expensett_ExpAm_18EBB522
_h/e|
a) a) a)
CO)
DEFAULT
on
column
Exp...
DF_Expensett_ExpAp_19DFD96B
h/2)
a) a) a)
(ao)
DEFAULT
on
column
Exp...
DF_Expensett_Expen_17F790F9
t/a)
a) a) a)
(Getdateo)
FOREIGN
KEY
FK_Expenset_Asset_1F9882C1
Cascade
Cascade
-——Enabled
|
For
Replication
AssetNo
REFERENCES
Expense,
FOREIGN
KEY
FK_Expensette_ECNo_IDBOGA4F
Cascade
Cascade.
©——Enabled
|
For
Replication
ECNo
REFERENCES
Expense,
FOREIGN
KEY
FK_Expensette_ERNo_1BC821..
Cascade
Cascade
Enabled
|
For
Replication
ERNo
REFERENCES
Expense,
PRIMARY KEY
(clustered)
PK_Expensel_228F11BSC12375F9
(v/a
(wa)
(a) (a)
EINo
1.
ExpenseCS1S325
dbo
Expenseltem:
FK__Expenselte
_E.
Name
Owner
Type
Created
datetime
1
[ExpenseRepor
|
dbo
usertable
2024-07-17
22:42:49,520
Column_name
Type
Computed
Length
Prec
Scale
Nullable
TinTralingBlanks
FxedLentlullnSource
Colton
1
[ERNe
rt
no 4
1
0
mtv
ve)
NULL
2
ERDesc
varchar
no 255 m0 no
0
‘SQL_Latin]_General_CP1_CLAS
3
ERSubmtDate
datetime
no 8
nova)
ve)
NULL
4
ERSiausDate
datetime
no 8
nova)
ve)
NULL
5
ERStatus
varchar
no 255 m0 no
0
‘SQL_Latin]_General_CP1_CLAS
6
—SubmitserNo
int
no 4
10
0m
va) ve)
NULL
7
Apprliserblo
int
no 4
10
0
yes
a)
ve)
NULL
‘dent
Seed
Increment
Not
For
Replication
1
[lo‘dentty
column
defined
|
NULL NULL NULL
owGuidCol
1.
[No
rowguidcel
column
defined
Data
_ocated_on_flegroup
1
[PRIMARY
index
pame
index_
description
index
keys
1
[PKEspenseR22F18237C0EE8D12
|
clustered,
unique,
primary
key
located
on
PRIMARY
_ERNo
‘constraint
type
‘constaint_name
‘elele_action
update_acion
status_enabled
status
forreplcaton
constaint_keys
4
CHECK
on
column
ERNo
‘CK_ExpenseRep_ERNo__00200768
n/a)
ve)
Enabled
|
For
Replication
(ERNo}>=(0)
5
DEFAULT
on
column
ERStatus..
DF__ExpenseRe_ERSta_02084FDA
(n/a)
ve) ve) ve)
(Getdate0)
6
DEFAULTon
column
ERStatus
DF__ExpenseRe_ERSta_02FC7413
(n/a)
ve) ve) ve)
(PENDING)
7
DEFAULT
on
column
ERSubmit..
DF__ExpenseRe_ERSub_011428A1
(n/a)
ve) ve) ve)
(Getdste0)
8
CHECK
Table
Level
ESDate
wo) ve)
Enabled
|
For
Replication
(ERStatusDate}>={ERSuibmtDate)
9
CHECKon
column
ERStatus
——_Estatus
oa) ve)
Enabled
|
For_Repicatin
_(ERStatus}~DENIED'
OR
[ERStatus}“
APPROVED!
10
FOREIGN
KEY
FK_ExpenseRe__AnprU_OSCDO4F7
No
Action
No
Action
Enabled
|
For
Replication
ApprUserNo
"
REFERENCES
ExpenseCSIS325
dbo.
Users
(Userlo)
12
FOREIGN
KEY
FK_ExpenseRe_Submi_O4E48C85
Cascade Cascade
Enabled
|
For
Replication
SubmitUserNto
B
REFERENCES
ExpenseCSIS325
dbo.
Users
(Userlo)
14
PRIMARY
KEY
(clustered)
PK_ExpenseR_22F15297C0EEBDI2_(h/a)
ve) ve) ve)
ERNo
Table
is
referenced
by
foreign
key
109%
FEI
Resuts
gil
Messages
Name
Owner
Type
Crested_datetime
1
[Oraint)
dbo
usertable
202407-17
224249517
Column_name
Type
Computed
Length
Prec
Scale
Nulable
ThiTrafingBlanks
FxedLenNlullnSource
Collation
1
(Oro
it
no 4
1
0
mtv)
ve)
NULL
2
“OreName
varchar
no 50 m0 no
0
‘SQL_Latin_General_CP1_CLAS
3
OrgParertNo
int
ne 4
10
0
yes
vay
7)
NULL
‘entity
‘Seed
Irerement
Not
For
Replication
1
[Noidentty
column
defined
NULL
NULL
NULL
Data_located_on_flegroup
1
[PRIMARY
index
rane
Index_descipion
index
keys
1
[Pk
orgtnt
“A208
EB46S5FECESEO”]
ctstered
unique,
pay
key
located
on
PRIMARY
OrgNo
constraint
type
-constaint_name_
delete_action
update_action
status_enabled
status
for_replication
_constraint_keys.
1
(CHECKCon
coiumn
GraNo
|]
CK_OraUnt_OrgNo_75A278F5
(n/a)
(wa)
Enabled
|s_For_Replication
—((OrgNo}>=(0))
2
CHECKon
column
OrgParentNo
CK
_OrgUnit__OrgPare__76969D2E
(n/a) (n/a)
Enabled
|s_For_Replication
((OrgParentNo}>=(0))
3
PRIMARY
KEY
(clustered)
PK_OrgUnit_420BEB465FEC65FO
(n/a) (n/a) (n/a) (n/a)
OrgNo
Table
is
referenced
by
foreign
key
1
ExpenseC51S326
dbo
Budgetem:
FKGudgette
_OraN.
2
ExpenseC$1$325
dbo
Users:
FK__Users__UserOraNo__7.
Table constraints are defined rules applied to table columns to ensure that the accuracy and
integrity of the data in the database is maintained. These rules enforce data validation and
consistency across tables. Constraints like primary keys ensure that each record is unique thus
the key itself must be unique and exist (not null). Another constraint, like a foreign key, is used
to link two tables together. Other constraints like check constraints are used to ensure that all
values in a defined column conform to a specified condition. By implementing constrains a
database designer can ensure that the database operates at its full potential by forcing users to use
the database as designed. Similarly, we have a designer that has given us constraints for life.
Deuteronomy 6:6-9 Says: “These commandments that I give you today are to be on your
hearts.:Impress them on your children. Talk about them when you sit at home and when you
walk along the road, when you lie down and when you get up.:Tie them as symbols on your
hands and bind them on your foreheads.:Write them on the doorframes of your houses and on
your gates” (English Standard Version Bible, 2001, Deut. 6:6-9). God gives us constraints, or
commandments, so that we may live life in the way that He designed us. By living in accordance
with God’s commandments, God can bring us to our full potential and live the abundant life that
Jesus intended for us. As Christian developers, it is important that we incorporate clearly defined
constraints in our designs. Because we understand the benefit of God’s constraints on our lives,
our designs should be a reflection of what we believe.
References
English Standard Version Bible. (2001). ESV Online. https://esv.literalword.com/
Morris, C. C. S. (2021). Database Systems. Design, Implementation and Management. In Zenodo
(CERN European Organization for Nuclear Research). https://doi.org/10.5281/zenodo.5599481
