소개글
1.데이터베이스 수업시간했던 기말과제입니다.가장 중요한 결과인 과제에 대한 평가는 학점은 a+ 나왔습니다.
2. 특히 디자인에 신경을 많이 썼으므로, 학점받기에 도움이 많이
될것입니다.
3. 보고서에 자세한 만든 사양, 구성, 참고자료등을 적어놓았으므로,
보시고 참고하시면 되겠습니다
P.S. 수업따라가랴, 숙제하랴, 바쁜 하루하루를 보내고 있을 우리 공대생분들에게
이 과제가 도움이 되었으면 좋겠습니다.
목차
설계과제 요약서1. 과제 목표
2. 과제 필요성
3. 설계 제한요소
4. 수행 내용 및 방법
5. 수행 결과
6. 효과 분석
제 1 장 서론
제 1 절 설계과제 목적
제 2 절 설계과제 필요성
제 3 절 설계과제 내용
1) 데이터 베이스 설계
2) User Inter Face 설계
3) 프로그램과 데이터베이스의 연동
제 4 절 진행 일정 및 개인별 담당분야
1. 진행일정
2. 개인별 담당 분야
제 2 장 시스템의 구조 및 구성
제 1 절 전체 구성도
1. 시스템 구성
2. 전체 구성도
제 2 절 데이터베이스 설계
1. 데이터베이스 개념적 설계
2. 논리 데이터베이스 설계(Logical Database Design)
3. 물리 데이터베이스 설계(Physical Database Design)
4. 데이터베이스 테이블 정의
5. 참고사항
제 3 절 데이터베이스 구현
제 3 장 결론
제 1 절 창의성 측면
제 2 절 기술적 측면
제 3 절 협동성 측면
제 4 장 참고문헌
제 5 장 부록
본문내용
1. 과제 목표데이터베이스의 이론과 실습을 통해 습득한 지식을 기반으로 SQL를 이용한 프로그래밍 으로 자동차 판매관리프로그램(a car sale management program)을 구현하는 데이터베이스설계 및 응용프로그램을 설계한다. 또한, 주어진 제한요소를 최대한 고려하여, 관련 프로그램에 따른 데이터관리를 최적화 할수 있는 설계를 하고, 실질적으로 최적화된 설계를 하였는가에 대한 것을 시각적인 결과물로 보여준다.
2. 과제 필요성
팀 프로젝트를 진행하면서 팀원들간의 협동을 통해 문제 해결 능력을 높이고, 경험을
쌓는다.
현재 사용되고 있는 시스템에 기초하여 자동차판매관리시스템을 만들어보고, 나아가
더 향상된 시스템으로 발전시킬 가능성을 제시한다.
점차 늘어나는 데이터와 그에 따른 수많은 관련 자료들을 필요시 빠르고 간편하게 찾
아 사용할 수 있게 한다.
이번 과제를 통해서 데이터베이스에 대한 설계 미 구현을 하여 창의력을 기를 수 있
고, 주어진 문제를 ER Win을 이용하여 직접 설계하여보고, 실질적으로 데이터베이스
를 구축하여 본다.
3. 설계 제한요소
개발 참여자들의 경험의 부족과 능력의 한계로 인하여 관련 시스템의 완성도가 떨어
질 가능성이 있다.
프로젝트 추진 일정이 약 2달 정도로 짧고, 중간고사와 다른 과목들의 과제 그리고
다른 여러 프로젝트의 참여로 인하여 정해진 시간동안에 목표로 한 성능에 부합하는
자동차판매관리시스템”의 완성을 못할 수도 있다.
프로젝트를 진행하여 상황에 따라 목표의 수정이 있을 수 있다.
시중에 나와있는 웹 시스템이랑 비교해서 질이 떨어져서 개발 참여자들의 의욕이 떨
어질 가능성이 농후하다.
프로젝트 진행 마감이 다가옴으로써, 계획했던 큰 기능을 먼저 완성하고, 세부기능을
포기하는 결과가 나타날 가능성이 높아진다.
참고 자료
[1] Conte, S. and Hall, R., A measure of execution path complexity, Comm. ACM, Vol.31, No.2, pp. 188-200, 1998.[2] Bellman, R., Introduction to Matrix Analysis, 2nd Ed., p.234, McGraw-Hill, New York, 1979.
압축파일 내 파일목록
데이터베이스최종보고서.hwp
프로젝트ER-win/CarSaleManage_V2.erwin
프로젝트ER-win/CarTable_v2.sql
프로젝트ER-win/OPTION.SQL.txt
프로젝트ER-win/TEST.SQL.txt
AutoSaleManage/AutoSaleManage.sln
AutoSaleManage/AutoSaleManage.suo
AutoSaleManage/AutoSaleManage/AgencyManager.cs
AutoSaleManage/AutoSaleManage/AutoSaleManage.csproj
AutoSaleManage/AutoSaleManage/BranchForm.cs
AutoSaleManage/AutoSaleManage/BranchForm.Designer.cs
AutoSaleManage/AutoSaleManage/BranchForm.resx
AutoSaleManage/AutoSaleManage/BranchRegForm.cs
AutoSaleManage/AutoSaleManage/BranchRegForm.Designer.cs
AutoSaleManage/AutoSaleManage/BranchRegForm.resx
AutoSaleManage/AutoSaleManage/Common.cs
AutoSaleManage/AutoSaleManage/DBManager.cs
AutoSaleManage/AutoSaleManage/DeptForm.cs
AutoSaleManage/AutoSaleManage/DeptForm.Designer.cs
AutoSaleManage/AutoSaleManage/DeptForm.resx
AutoSaleManage/AutoSaleManage/DeptRegForm.cs
AutoSaleManage/AutoSaleManage/DeptRegForm.Designer.cs
AutoSaleManage/AutoSaleManage/DeptRegForm.resx
AutoSaleManage/AutoSaleManage/EmpForm.cs
AutoSaleManage/AutoSaleManage/EmpForm.Designer.cs
AutoSaleManage/AutoSaleManage/EmpForm.resx
AutoSaleManage/AutoSaleManage/EmpRegForm.cs
AutoSaleManage/AutoSaleManage/EmpRegForm.Designer.cs
AutoSaleManage/AutoSaleManage/EmpRegForm.resx
AutoSaleManage/AutoSaleManage/Form10.cs
AutoSaleManage/AutoSaleManage/Form10.Designer.cs
AutoSaleManage/AutoSaleManage/Form10.resx
AutoSaleManage/AutoSaleManage/Form3.cs
AutoSaleManage/AutoSaleManage/Form3.Designer.cs
AutoSaleManage/AutoSaleManage/Form3.resx
AutoSaleManage/AutoSaleManage/Form4.cs
AutoSaleManage/AutoSaleManage/Form4.Designer.cs
AutoSaleManage/AutoSaleManage/Form4.resx
AutoSaleManage/AutoSaleManage/Form5.cs
AutoSaleManage/AutoSaleManage/Form5.Designer.cs
AutoSaleManage/AutoSaleManage/Form5.resx
AutoSaleManage/AutoSaleManage/Form6.cs
AutoSaleManage/AutoSaleManage/Form6.Designer.cs
AutoSaleManage/AutoSaleManage/Form6.resx
AutoSaleManage/AutoSaleManage/Form7.cs
AutoSaleManage/AutoSaleManage/Form7.Designer.cs
AutoSaleManage/AutoSaleManage/Form7.resx
AutoSaleManage/AutoSaleManage/Form9.cs
AutoSaleManage/AutoSaleManage/Form9.Designer.cs
AutoSaleManage/AutoSaleManage/Form9.resx
AutoSaleManage/AutoSaleManage/LoginForm.cs
AutoSaleManage/AutoSaleManage/LoginForm.Designer.cs
AutoSaleManage/AutoSaleManage/LoginForm.resx
AutoSaleManage/AutoSaleManage/Main.cs
AutoSaleManage/AutoSaleManage/Main.Designer.cs
AutoSaleManage/AutoSaleManage/Main.resx
AutoSaleManage/AutoSaleManage/Program.cs
AutoSaleManage/AutoSaleManage/SaleForm.cs
AutoSaleManage/AutoSaleManage/SaleForm.Designer.cs
AutoSaleManage/AutoSaleManage/SaleForm.resx
AutoSaleManage/AutoSaleManage/test.cs
AutoSaleManage/AutoSaleManage/test.Designer.cs
AutoSaleManage/AutoSaleManage/test.resx
AutoSaleManage/AutoSaleManage/viewCustomer.cs
AutoSaleManage/AutoSaleManage/viewCustomer.Designer.cs
AutoSaleManage/AutoSaleManage/viewCustomer.resx
AutoSaleManage/AutoSaleManage/bin/Debug/AutoSaleManage.exe
AutoSaleManage/AutoSaleManage/bin/Debug/AutoSaleManage.pdb
AutoSaleManage/AutoSaleManage/bin/Debug/AutoSaleManage.vshost.exe
AutoSaleManage/AutoSaleManage/bin/Debug/sqlnet.log
AutoSaleManage/AutoSaleManage/obj/AutoSaleManage.csproj.FileListAbsolute.txt
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.BranchForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.BranchRegForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.csproj.GenerateResource.Cache
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.DeptForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.DeptRegForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.EmpForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.EmpRegForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.exe
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form10.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form3.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form4.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form5.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form6.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form7.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form9.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.LoginForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.MainForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.pdb
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Properties.Resources.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.SaleForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.test.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.viewCustomer.resources
AutoSaleManageAutoSaleManageobjDebugRefactor
AutoSaleManage/AutoSaleManage/obj/Debug/TempPE/Properties.Resources.Designer.cs.dll
AutoSaleManage/AutoSaleManage/Properties/AssemblyInfo.cs
AutoSaleManage/AutoSaleManage/Properties/Resources.Designer.cs
AutoSaleManage/AutoSaleManage/Properties/Resources.resx
AutoSaleManage/AutoSaleManage/Properties/Settings.Designer.cs
AutoSaleManage/AutoSaleManage/Properties/Settings.settings
프로젝트ER-win/CarSaleManage_V2.erwin
프로젝트ER-win/CarTable_v2.sql
프로젝트ER-win/OPTION.SQL.txt
프로젝트ER-win/TEST.SQL.txt
AutoSaleManage/AutoSaleManage.sln
AutoSaleManage/AutoSaleManage.suo
AutoSaleManage/AutoSaleManage/AgencyManager.cs
AutoSaleManage/AutoSaleManage/AutoSaleManage.csproj
AutoSaleManage/AutoSaleManage/BranchForm.cs
AutoSaleManage/AutoSaleManage/BranchForm.Designer.cs
AutoSaleManage/AutoSaleManage/BranchForm.resx
AutoSaleManage/AutoSaleManage/BranchRegForm.cs
AutoSaleManage/AutoSaleManage/BranchRegForm.Designer.cs
AutoSaleManage/AutoSaleManage/BranchRegForm.resx
AutoSaleManage/AutoSaleManage/Common.cs
AutoSaleManage/AutoSaleManage/DBManager.cs
AutoSaleManage/AutoSaleManage/DeptForm.cs
AutoSaleManage/AutoSaleManage/DeptForm.Designer.cs
AutoSaleManage/AutoSaleManage/DeptForm.resx
AutoSaleManage/AutoSaleManage/DeptRegForm.cs
AutoSaleManage/AutoSaleManage/DeptRegForm.Designer.cs
AutoSaleManage/AutoSaleManage/DeptRegForm.resx
AutoSaleManage/AutoSaleManage/EmpForm.cs
AutoSaleManage/AutoSaleManage/EmpForm.Designer.cs
AutoSaleManage/AutoSaleManage/EmpForm.resx
AutoSaleManage/AutoSaleManage/EmpRegForm.cs
AutoSaleManage/AutoSaleManage/EmpRegForm.Designer.cs
AutoSaleManage/AutoSaleManage/EmpRegForm.resx
AutoSaleManage/AutoSaleManage/Form10.cs
AutoSaleManage/AutoSaleManage/Form10.Designer.cs
AutoSaleManage/AutoSaleManage/Form10.resx
AutoSaleManage/AutoSaleManage/Form3.cs
AutoSaleManage/AutoSaleManage/Form3.Designer.cs
AutoSaleManage/AutoSaleManage/Form3.resx
AutoSaleManage/AutoSaleManage/Form4.cs
AutoSaleManage/AutoSaleManage/Form4.Designer.cs
AutoSaleManage/AutoSaleManage/Form4.resx
AutoSaleManage/AutoSaleManage/Form5.cs
AutoSaleManage/AutoSaleManage/Form5.Designer.cs
AutoSaleManage/AutoSaleManage/Form5.resx
AutoSaleManage/AutoSaleManage/Form6.cs
AutoSaleManage/AutoSaleManage/Form6.Designer.cs
AutoSaleManage/AutoSaleManage/Form6.resx
AutoSaleManage/AutoSaleManage/Form7.cs
AutoSaleManage/AutoSaleManage/Form7.Designer.cs
AutoSaleManage/AutoSaleManage/Form7.resx
AutoSaleManage/AutoSaleManage/Form9.cs
AutoSaleManage/AutoSaleManage/Form9.Designer.cs
AutoSaleManage/AutoSaleManage/Form9.resx
AutoSaleManage/AutoSaleManage/LoginForm.cs
AutoSaleManage/AutoSaleManage/LoginForm.Designer.cs
AutoSaleManage/AutoSaleManage/LoginForm.resx
AutoSaleManage/AutoSaleManage/Main.cs
AutoSaleManage/AutoSaleManage/Main.Designer.cs
AutoSaleManage/AutoSaleManage/Main.resx
AutoSaleManage/AutoSaleManage/Program.cs
AutoSaleManage/AutoSaleManage/SaleForm.cs
AutoSaleManage/AutoSaleManage/SaleForm.Designer.cs
AutoSaleManage/AutoSaleManage/SaleForm.resx
AutoSaleManage/AutoSaleManage/test.cs
AutoSaleManage/AutoSaleManage/test.Designer.cs
AutoSaleManage/AutoSaleManage/test.resx
AutoSaleManage/AutoSaleManage/viewCustomer.cs
AutoSaleManage/AutoSaleManage/viewCustomer.Designer.cs
AutoSaleManage/AutoSaleManage/viewCustomer.resx
AutoSaleManage/AutoSaleManage/bin/Debug/AutoSaleManage.exe
AutoSaleManage/AutoSaleManage/bin/Debug/AutoSaleManage.pdb
AutoSaleManage/AutoSaleManage/bin/Debug/AutoSaleManage.vshost.exe
AutoSaleManage/AutoSaleManage/bin/Debug/sqlnet.log
AutoSaleManage/AutoSaleManage/obj/AutoSaleManage.csproj.FileListAbsolute.txt
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.BranchForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.BranchRegForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.csproj.GenerateResource.Cache
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.DeptForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.DeptRegForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.EmpForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.EmpRegForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.exe
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form10.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form3.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form4.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form5.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form6.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form7.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Form9.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.LoginForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.MainForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.pdb
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.Properties.Resources.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.SaleForm.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.test.resources
AutoSaleManage/AutoSaleManage/obj/Debug/AutoSaleManage.viewCustomer.resources
AutoSaleManageAutoSaleManageobjDebugRefactor
AutoSaleManage/AutoSaleManage/obj/Debug/TempPE/Properties.Resources.Designer.cs.dll
AutoSaleManage/AutoSaleManage/Properties/AssemblyInfo.cs
AutoSaleManage/AutoSaleManage/Properties/Resources.Designer.cs
AutoSaleManage/AutoSaleManage/Properties/Resources.resx
AutoSaleManage/AutoSaleManage/Properties/Settings.Designer.cs
AutoSaleManage/AutoSaleManage/Properties/Settings.settings