CAPSTONE PROJECT KAP 1 2 KAP G ROUP

CAPSTONE PROJECT KAP 1

2 KAP G ROUP 1. Phương. BM (Leader) 2. Vinh. TD (Vice Leader) 3. Chung. BT (Designer) 4. NgọcĐM (Developer) 5. Ngọc. DB (Test leader) KAP

3 C ONTENTS 1. Introduction 2. Project Management 3. Requirement Specification 4. Implementation 5. Result and Conclusions 6. Demo KAP

4 I DEA’S O RIGIN KAP

I DEA’S O RIGIN 5 ØWHAT IS “KARAOKE”? ( KARA IS “EMPTY”, AND ŌKESUTORA : ORCHESTRA ) ØCLASSIFICATION: KARAOKE BOX AND KARAOKE FAMILY ØKARAOKE BOX IS THE MOST POPULAR USED. ØSERVICE : § WRITE NAME OF SONGS AND SEND REQUEST OUT § DIRECT REMOTE EVERYTHING ON TOUCH SCREEN MONITOR KAP

6 I DEA’S O RIGIN KAP

7 E XISTING P RODUCTS

8 O BJECTIVE S YSTEM A System help user can choose and control karaoke process by Android Mobile

9 R OLE AND R ESPONSIBILITIES Role Member General manager, Technical leader Phuong. BM Technical leader, Developer Vinh. TD Test leader Ngoc. DB Developer Ngoc. DM Analysis, Designer Chung. BT KAP

10 S OFTWARE P ROCESS M ODEL Requirement Design Implementation Verification Maintain del erfall Mo Wat KAP

11 Project Plan

12 F UNCTIONAL R EQUIREMENTS Manage connection Remote Karaoke Search song Create favorite songs Mobile user Score by user KAP

13 F UNCTIONAL R EQUIREMENTS Collect Karaoke song’s info Edit Karaoke song’s info Create all playlist Create suggest list Manager Schedule making playlist KAP

14 N ON- F UNCTIONAL R EQUIREMENTS q Usability q Maintain and develop q Platform compatibility q Resource constraints (processor speed, memory, disk space, network bandwidth, etc. )

15 • D EVELOPMENT E NVIRONMENTS Hardware LG, Samsung mobile phone with Android OS • Software v Server Software (SQLServer, Visual studio 2010). NET Frame 4. 0 v PC Client J 2 EE Eclipse Java JDK 6. 24 VLC Media Player v Mobile Android SDK Java JDK 6. 24 Eclipse KAP

16 C OMMUNICATION P ROTOCOLS • Connection : Wi-Fi • Protocol: Http protocol • Data type: video files (mp 4, avi, mpg, flv…) KAP

17 U SER I NTERFACE D ESIGN KAP

18 F UNCTIONAL D ESIGN Database • Store video file • Create database via XML file • Collect , add song’s information Control • Add, edit , remove • Update played time • Auto create playlist KAP

19 F UNCTIONAL D ESIGN Connection • Find, connect with Access Point • User add server to connect with PC Client by IP Address and Port Control • User can play, pause, next, previous, fullscreen song in list • View list song is playing • Play suggest list • Control volume • Seek Search • Searching song on Database by song’s name, lyric or singer • Play a song in this list • Add song into favorite list KAP

20 D ATABASE D ESIGN q. PC-Server: OLE DB. NET Data Provider (Microsoft Access) q. Mobile phone: SQL Lite q. Data table : One main table contains all song’s information KAP

D ATABASE D ESIGN 21 KAP-SS KAPlus Name Description Select Command Video Main table, Store all songs information SELECT [No], Title, Duration, Artist, Description, Album, Played. Time, URI Table Adapter FROM Video. Table. Adapter Column No Title Duration Artist Description Album Played. Time URI Data Type Text Memo Number Memo Null Option No No Yes Yes Yes No Is FK No No Column id location title_simple favourite lyric source Data Type int varchar varchar Null Option No No Yes Yes Is FK No No No No Is PK Yes No Note KAP

T ECHNICAL DESIGN 22 HTTP Request - Response Client Mobile Java TCP-IP Android Server. NET Framework DB KAP

23 A RCHITECTURE M ODEL q. Client-Server q. Interaction-Oriented (MVC and PAC)

24 T ESTING V – model

T ESTING R ESULT 25 Test Report 89 Sum of Test. Case 1 Number of Test. Case 2 3 1 Number of Test. Case Failed 2 3 1 Number of Test. Case Pending 2 3 Defect Number of opening defect Number of Closed defect 100 143 190 26 16 0 33 0 0 59

I MPLEMENTED T ECHNICAL P ROBLEMS 26 Having dependence on VLC media player New programming language Some problem with emulator and real devices

L IMITATIONSAND F UTURE I MPROVEMENT 27 Limitations: Can’t save song’s information with song’s file. Don’t have portability Future Improvement: Save user playlist (mobile or web) Search unavailable song from internet Synchrony with social network

C ONCLUSIONS 28 Future: • Continue developing • Deployed to Android Market • Make product professional and popular

29 D EMO KAP

T HANKS FOR L ISTENING 30 KAP