Administration of comic books effectiveness in club #2.


50 views
Uploaded on:
Description
Seeking comic books accessible by Genre, distributed date and class. ... individuals inspired by comic books get together to share the thoughts regarding comic and draw a ...
Transcripts
Slide 1

Administration of comic books productivity in club #2 0815 조장 : 문승현 2003011836 남경은 2003011870 이명훈 2004011767

Slide 2

Contents Introduce Main item Main capacity Grill Zayu circumstance Grill Zayu situation(interview) Entity Relationship Diagram Schema Quary

Slide 3

Introduce The reason for this framework is precise books control of liveliness gathering. Likewise, individuals from this gathering can consent to the due date through the late expense administration framework.

Slide 4

Main item Management of comic books in club be not completed proficiency. so we made an arrangement of library administration for comic books. We classified as name of books and writer. What\'s more we connected the framework with individuals. In this way It can bring the effectiveness administration up in club.

Slide 5

Main capacity Categorized via looking framework - Searching comic books accessible by Genre, distributed date and class. The late expense framework - The late charge framework can compute it consequently. as indicated by we can see the all late expense and can charge of it.

Slide 6

Main capacity The loaning administration - The loaning administration framework will demonstrate to you who look at books from library and the rundown of look at. Additionally it will give the information about accessible books to loan.

Slide 7

Grill Zayu Space for club " s state individuals keen on comic books get together to share the thoughts regarding comic and draw a toon. Likewise they have loads of exercises like as a display.

Slide 8

Grill Zayu Looks in club " s room They lost numerous books by leaving them be so loaning is not accessible but rather can read books just in the space for individuals .

Slide 9

Grill Zayu Club(Interview)

Slide 10

대여코드 학 과 연체구간 만화책 코 드 학 번 회 원 이 름 대여일 ` 대여가능여부 학 번 휴대폰 번 호 성 별 반납예정일 반납일 주 소 출판사 저 자 연체코드 연체금 출시일 대여코드 누계액 만화책코드 장 르 ERD(Entity Relationship Diagram) 대여/반납 1 회 원 1 n 만 화 책 연체금 누계 관리

Slide 11

Table_name=member Attribute_name(1) = "st_num" Attribute_type(1) = "number" Attribute_length(1) = "10" Attribute_name(2) = "st_name" Attribute_type(2) = "varchar2" Attribute_length(2) = "20" Attribute_name(3) = "major" Attribute_type(3) = "varchar2" Attribute_length(3) = "40" Attribute_name(4) = "phone_num" Attribute_type(4) = "varchar2" Attribute_length(4) = "15" Attribute_name(5) = "address" Attribute_type(5) = "varchar2" Attribute_length(5) = "150" Attribute_name(6) = "sex" Attribute_type(6) = "singe" Attribute_length(6) = "3" Table_name=comic_book Attribute_name(1) = "book_code" Attribute_type(1) = "varchar2" Attribute_length(1) = "75" Attribute_name(2) = " book_name\' Attribute_type(2) = "varchar2" Attribute_length(2) = " 50\' Attribute_name(3) = "writer" Attribute_type(3) = "varchar2" Attribute_length(3) = "30" Attribute_name(4) = "classification" Attribute_type(4) = "varchar2" Attribute_length(4) = "20" Attribute_name(5) = " publishing_company\' Attribute_type(5) = "varchar2" Attribute_length(5) = "30" Attribute_name(6) = " publication_date\' Attribute_type(6) = " date\' Attribute_length(6) = "20" Schema

Slide 12

Table_name=lend_back Attribute_name(1) = " lend_code\' Attribute_type(1) = "varchar2" Attribute_length(1) = "75" Attribute_name(2) = "book_code" Attribute_type(2) = "varchar2" Attribute_length(2) = "75" Attribute_name(3) = "st_num" Attribute_type(3) = "number" Attribute_length(3) = "10" Attribute_name(4) = "lend_date" Attribute_type(4) = " date\' Attribute_length(4) = \'20 Attribute_name(5) = "exp_return_date" Attribute_type(5) = " date\' Attribute_length(5) = "20" Attribute_name(6) = " return_date\' Attribute_type(6) = " date\' Attribute_length(6) = \'20 " Attribute_name(7) = "late_day" Attribute_type(7) = " number\' Attribute_length(7) = "20" Attribute_name(8) = "late_fee" Attribute_type(8) = "number" Attribute_length(8) = "10" Attribute_name(9) = "lend_possibility" Attribute_type(9) = "burn" Attribute_length(9) = "4" Table_name=late_fee_management Attribute_name(1) = "late_fee_code" Attribute_type(1) = "varchar2" Attribute_length(1) = "75" Attribute_name(2) = " lend_code\' Attribute_type(2) = "varchar2" Attribute_length(2) = " 75\' Attribute_name(3) = "whole" Attribute_type(3) = "number" Attribute_length(3) = "10" Schema

Slide 13

Quary 자료입력 쿼리 예 1)member 테이블에 명훈이의 회원 정보 입력 embed into part values( 2004011767, " 이명훈 \', " 산업정보공학 \', \'011-9315-8035\', " 통영시 용남면 동달리 동남 APT 1 차 1003 호 \', " 남 \')

Slide 15

Quary 예 2)comic_book 테이블에 자료입력 embed into comic_book values( 1, \'ONEPIECE01\', \'EIICHIRO ODA\', " 모험 \', " 대원씨아이 \', \'1999/01/09\')

Slide 17

Quary 기능관련 쿼리 1) 대여관리 예 )\' 승현이가 어떤책을 몇일날 빌려갔는가 ?\' select st_name, book_name, late_day from part, comic_book, lend_return where st_name = " 문승현 " and member.st_num = lend_return.st_num and comic_book.book_code = lend_return.book_code

Slide 19

Quary 2) 연체금 누계액 예 )\' 승현이가 어떤책을 빌렸고 연체금 누계가 얼마인가 ?\' select st_name, book_name, late_fee, aggregate from part, comic_book, lend_return, late_fee_management where st_name = " 문승현 " and member.st_num = lend_return.st_num and comic_book.book_code = lend_return.book_code and late_fee_management.lend_code= lend_return.lend_code request by entirety

Slide 21

Quary 3) 카테고리별 ( 예는 출시일 ) 책 제목 검색 예 )\'1999/01/01 부터 2004/01/01 까지 출판된 책 제목 검색 " select book_name from comic_book where publication_date between \'1999/01/01\' and \'2004/01/01\' request by publication_date ;

Recommended
View more...