CC7174 – WK1

  1. Objectives
    1. Certify of MySQL
    2. Data sync between MySQL and Oracle
    3. comparison with MySQL and Oracle, NoSQL
    4. prepare with python and data analytics
    5. Develop and EER model of user requirements
    6. Map an EER model to a database implementation model
    7. Verify and evaluate typical examples of the implementation
    8. Revise a design in light of implementation and performance considerations
  2. Contents
    1. WK1-Intro
      1. Final report with 2500 words (Harvard referencing?)
      2. Oracle environment
      3. SQL *Plus statement groups
        1. Data definition: CREATE TABLE / VIEW / ALTER / DROP
        2. Security / Authorization: GRANT / REVOKE
        3. Data control: COMMIT / LOCK / ROLLBACK
        4. Data manipulation: SELECT / INSERT / UPDATE / DELELTE
        5. Miscellaneous: DESCRIBE / SPOOL
    2. WK1-Lecture
      1. SQL Fundamentals
        1. SQL (Structured Query Language): access and manipulate DB;
        2. Std by ANSI for RDBMS
      2. SQL characterization
        1. structure in any DB in form of TABLES;
          1. row: a set of data related to a specific entity / record;
          2. column: a characteristics of the data
        2. Two main languages in SQL
          1. DML (Data Manipulation Language): retrieve, modify and insert info from / to the database: SELECT / INSERT / UPDATE / DELETE;
          2. DDL (Data Definition Language):
      3. SQL SELECT statement
        1. SELECT [* | DISTINCT] column FROM table WHERE condition [AND | OR | LIKE condition] [GROUP BY] [HAVING “conditions”] [ORDER BY “condition-list”] [ASC | DESC]
        2. functions: Projection / Selection / Joining
        3. Concatenating columns in a table:
          1. SELECT Fname || Lname AS “Author Name” FROM Author;
        4. Display data by using literals
          1. SELECT Title || ‘published by ‘ || P_Code AS “Books Details” FROM Books;
        5. Display DISTINCT records in a table
          1. SELECT DISTINCT Publisher FROM Books;
        6. Display table structure (In Oracle only)
          1. DESCRIBE Books; / DESC Books;
        7. Using DUAL table
          1. SELECT SYSDATE, USER FROM dual;
          2. SELECT (24-3)*2/(12+15) AS “Expression Output” FROM Dual;
          3. SELECT “Todays Date is: 02-JUL-11” FROM DUAL;
      4. iSQL *PLUS overview (Oracle only)
        1. Oracle tool / environment that recognizes and submit SQL statements to Oracle Server for execution and contains its own command language;
        2. browser based interface which uses SQL *Plus processing engine in a 3-tier model
          1. Client Tier — Middle Tier — Database Tier
          2. Web browser -(HTTP)- application server -(ORACLE NET)- Oracle database);
      5. SQL statement VS iSQL *Plus commands
      6. Tutorial questions
    3. WK1-Workshop
      1. Conceptual database database?
      2. Logical Schema?
  3. Follow-ups
    1. Download and install Oracle SQL Developer
      1. Login Oracle
      2. Go to Download
  4.  References
    1. Oracle SQL developer tutorial:
CC7174 – WK1

FC7P05 -LMU MSc Project- WK1

Computing Librarian Lynn:

Module Objectives.

  1.  Principles
    1. 5-7年磨一劍的目標, researcher and doctor;
    2. Prepare for management of 人工智能/能源科技/生物科技
    3. Complement of you weakness / strengths
    4. continuous writing is an integral part of the research process
    5. allow you to take control of your learning
    6. grow the wings to take you to a higher level of intellectual endeavour
  2. Hours ( / 20H)
  3. Module guidelines
    1. Topics selection from blank (subject that inspires you and drive you to work)
      1. Perform more reading (papers, Journals)
      2. Discuss with tutors and ask for suggestions
      3. Attend seminars
      4. Read previous theses
      5. Ask friends working in industry for ideas
    2. Rephrase your question as your aim and identify the three to five objectives
      1. Is the topic “research oriented” piece of work?
      2. Domain understanding, awareness of difficulties and understanding of fundamental questions.
    3. Proposal needs to be clear and sound
      1. Contents including: Title, rationale, question, aim, objectives, methodology, expected outcome, deliverables, work program and initial references
      2. Realistic timetable with actions and outcomes
      3. Project categories
        1. research oriented
          1. problem solving, algorithm enhancement, software quality, novel approach, fundamental issues;
          2. topics: networking, software engineering, data mining, security, intelligent systems, database, wireless technology, information system, business information system, grid computing, teaching and learning, image processing;
        2. critical review
    4. Works
      1. Original investigation
    5. Research elements
      1. problem solving, algorithm enhancement, software quality, novel approach, fundamental issues
      2. Topics: networking, software engineering, data mining, security, intelligent systems, database, wireless technology, information system, business information system, grid computing, teaching and learning, image processing…
    6. Supervision
      1. agree the frequency and format of meetings and having done
      2. preparing and making themselves available for meeting to find that the student fails to turn up without notice or explanation
      3. inform him/her of your progress by agreed frequency and channel, ask for advice, ask if your progress is satisfactory and discuss and discuss your future action plans
      4. Accept criticism gracefully, it is for your own good and you will produce a better dissertation for it
      5. get higher marks if you follow your supervisor’s guidance
      6. well-prepared to the meeting and so keep it productive, focused and if possible short
      7. welcome to attend the departmental weekly seminars as they might be very helpful
    7. Librarian support
      1. the computing librarian Lynn Crothall:
    8. Talk to different members of staff and ask for papers, Journals and articles
    9. Common Past Problems
      1. do not know how to write a proposal
      2. start the project late
      3. do not consult their supervisors
      4. are unable to find other directions when they get stuck
      5. find a lack of resources and unavailability of software
      6. do not engage with the project
      7. do not conduct a thorough review of the literature
      8. demonstrate little evidence of awareness of other work
      9. do not research the topic fully
      10. have problems writing a thesis (organisation, structure, coherence, style, evaluation of own work, references…)
      11. do not report their work fully
  4. Project Plan and deliverables
    1. Time tables and outcomes
    2. Meeting frequency with advisor
    3. timetable might be in the form of a bar chart or a series of timed milestones
    4. starts from reading the literature review and finishes with submitting the dissertation
  5. Topic selection
    1. Children online studying with Moodle platform in MJ education
      1. with paypal
    2. Wiki as Knowledge management in manufacturing – case study
    3. Mobile app for MJ learning assisting STEM lessons
    4. WeChat programming with enterprise mgt, MJG CRM and project mgt
    5. Mobile visual inspection
    6. Mobile broadcasting with API and payment
    7. Raspberry PI with RFID tag system in CY manufacturing
    8. Raspberry PI with video advertising system (check everbest / ezone)
    9. Knowledge management with Wikipedia and AI in CY manufacturing
    10. AR with education
    11. enterprise cybersecurity app
    12. Enterprise System / Mobile in manufacturing / Barcode in Mobile
    13. Preparation:
      1. Mobile / Programming and data manipulation / Reporting
    14. 流程系統化及知識系統
    15. Mobile oa
    16. wechat app to solve a problem?
    17. AI preparation
    18. Enterprise system implementation – Children care / Manufacturing
  6. Others
    1. Differences of dissertation and thesis
      1. UK: dissertation is the project report in final year of postgraduate study, while thesis is describing work for research-degree / doctoral degree;
      2. Canada / USA: dissertation for doctoral degree while, thesis for master degree;
    2. Mobile / ERP
      1. Tasks
        1. Assist operations in CY
          Assist operations in edu
      2. Applications
      3. Education
      4. Workplace
      5. Manufacturing
  7. Project Proposal
  8.  References:
    1. Writing up research: a statistics perspective.
    2. Microsoft Azure cognitive services.
    3. Topics of Dissertation
    4. Planning and conducting a dissertation research project (University of Leicester)
    5. Writing a dissertation (University of Leicester)
    6. A Guide to Writing your Masters Dissertation
    7. Succeeding with Your Master’s Dissertation – A step-by-step Handbook (
    8. Dissertation guidelines by LSE.
      1. Dissertation guide
      2. Guide to Writing MSc Dissertation (PDF)
    9. Dissertation timetable by University of Sussex.
  9. Wordings
    1. In other words…
FC7P05 -LMU MSc Project- WK1

CC7173 – WK-0

Useful links:



  1.  Objectives:
    1. HTML5 and Android
    2. Read and familiar book 1 to 3
    3. Familiar with mobile security, research and development, mobile education
  2. Contents
  3. Indicative Reading
    1. Recommend Textbooks
      1. F. DiMarzio, 2017, beginning android programming with android studio, john wiley& Sors Ltd, fourth edition, ISBN 9781118705599. (Core)
      2. Joseph Annuzzi, Jr. etc. 2016, Introduction to Android Application Development: Android Essentials, 5th Edition, ISBN-13: 9780134433646 (Essential readings)
      3. Joseph Annuzzi, Jr. etc. 2015, Advanced Android Application Development, 4th Edition ISBN-13: 9780134076416 (Supplementary)
      4. Darcey L., Conder S., (2010), Sams Teach Yourself Android Application Development in 24 Hours,1 edition, ISBN-10: 0321673352
      5. Wei-Meng L., 2012, Beginning Android 4 Application Development, Wrox; ISBN: 978 -1118199541
    2. Other Reading List
      1. Mednieks Z.,Dornin L., MeikeG. B., Nakamura M., 2012, Programming Android, 2nd Edition, O’Reilly Media, Inc, ISBN-13: 978- 1-4493- 1664-8, (e- textbook is available online via university library) Android Developer Homepage, (last accessed on 12/04/2013)
      2. Ray J., (2011), Sams Teach Yourself iOS 5 Application Development in  24 Hours, 3rd Edition, Sams, ISBN -10: 067233576X
      3. Alencar p., Cowan D., (2012), Handbook of Research on Mobile Software Engineering: Design, Implementation and Emergent Applications, Idea Group, ISBN -10: 1466616105
      4. Salmre I., (2005), Writing Mobile Code: Essential Software Engineering for  Building Mobile Applications, Addison Wesley, ISBN -10: 0321269314.
      5. Rogers Y., Sharp H., Preece J., (2011), Interaction Design: Beyond Human- Computer Interaction, John Wiley & Sons, 3rd edition, ISBN-10: 0470665769.
      6. Nahavandipoor V., (2012), iOS 5 Programming Cookbook: Solutions & Examples for iPhone, iPad, and iPod touch Apps, Oreilly, ISBN -10:1449311431
      7. Turner J., (2011), Developing Enterprise iOS Applications: iPhone and  iPad  Apps for Companies and Organizations, Oreilly, ISBN -10: 1449311482  Ray J., (2011), Sams Teach Yourself iOS 5 Application Development in  24  Hours, 3rd Edition, Sams, ISBN -10: 067233576X
      8. Gargenta M., (2011), Learning Android, O’Reilly Media, ISBN: 9781449390501
      9. Dalrymple M., Knaster S., (2008), Learn Objective-C on the Mac (Learn Series), APRESS, ISBN -10: 1430218150
      10. Ali M. (2009), iPhone SDK 3 Programming: Advanced Mobile Development for  Apple iPhone and iPod Touch, John Wiley & Sons, ISBN -13:978m-0470683989
      11. Ali M. (2010), iPhone SDK 4 Advanced Programming: Advanced Application  Development for Apple iPhone and iPod Touch, ISBN-13: 978-0470971239
      12. Meier R. (2010), Professional Android 2 Application Development (Wrox Programmer to Programmer) [Paperback], John Wiley & Sons, ISBN -13: 978- 0470565520
      13. Lewis R. (2010), iPhone and iPad Apps for Absolute Beginners (Books for Professionals by Professionals, APRESS, ISBN-13: 978 -1430227007
      14. Jipping M. J. (2007), Smartphone Operating System Concepts with Symbian OS: A Tutorial Guide (Symbian Press), John Wiley & Sons, ISBN-13: 978- 0470034491
      15. Babin, S. (2005) Developing Software for Symbian OS: An introduction to creating smart phone applications in C++, John Wiley & Sons, ISBN: 0470018453
      16. Dale N (2004), Programming and Problem Solving with C++ (Paperback), Jones & Bartlett Publishers Inc., U.S.; Edition 4, ISBN: 0763707988
      17. Deitel H. M., Deitel P. J., Goldberg A. B. (2004), Internet & World Wide Web  How to Program. Prentice Hall, 3rd edition, ISBN: 0131246828
      18. Deitel H. M. and Deitel, P. J. (2005), C++ How to Program, sxith  edition,  Pearson Education, ISBN:  0136152503
      19. Harrison, R. (2004) Symbian OS C++ for Mobile Phones Vol2, John Wiley and  Sons Ltd. ISBN: 0470871083
      20. Myers S. (2005), Effective C++: 55 Specific Ways to Improve Your Programs  and Designs, Addison Wesley, ISBN 0321334876
      21. Prinz P., Kirch-Prinz U. (2001), A Complete Guide to Programming in  C++, Jones and Bartlett Publishers International, ISBN 0763718173
      22. Schildt H. (2003), C++: A Beginner’s Guide, McGraw-Hill Education, ISBN 0072232153
      23. Stroustrup B. (2000), The C++ Programming Language, Special Edition,  Addison Wesley, ISBN 0201700735
      24. Stichbury, J. (2004) Symbian OS Explained: Effective C++ programming for smartphones, John Wiley & Sons, ISBN: 0470021306
      25. Stichbury, J., Jocobs, M. (2006) The acredited Symbian Developer Primer: fundamentals of symbian OS, John Wiley & Sons, ISBN: 0470058277
      26. Sutter H. (1999), Exceptional C++, Addison Wesley, ISBN 0201615622
      27. Thomas R., (19995), An Introductory Overview of Object Technology  – How to Understand Object Speak, – intro.pdf
      28. Welling, L. and Thomson, L. (2005), PHP and MySQL Web Development.  SAMS, 3rd ed., ISBN: 0672326728
    3. Web links
      1. Android learning resource,, last accessed on 29th September 2015
      3. iPhone developer,, accessed on 29th September 2015
      4. Download XAMPP (Apache, MySQL, PHP) environment,, accessed on 29th  September  2015
CC7173 – WK-0

Server / System administration


  1. Contents
    1. XCOPY
      1. xcopy /Y D:\backup\* D:\tmp
      2. xcopy /Y D:\backup\* \\network\share\MonBackup
    2. File deletion audit.
      1. Enable <Audit object access> in Security Settings > Local Policies > Audit Policy, by:
        1. Group Policy;
        2. Local Security Policy;
      2. Configure which files and folders are to be audited, approach:
        1. inherited, or
        2. Individuals;
        3. Properties > Security > Advanced > Auditing > Add > eg. Export > Delete / Delete subfolders and file
        4. Access attempts will be recorded in the server’s security logs which may be accessed using the Events Viewer;
      3. Windows backup (Wbadmin)
        1. VSScopy: A copy backup cannot be used for incremental or differential backups or restores;
        2. VSSfull: update log files which may badly affect 3rd backup software
          1. Incremental backup is based on Volume Shadow Copy (VSS) feature and due to Windows Server 2008 R2 limitations (this limitation is resolved in Windows 8) only one version of backed up data can be stored in a network shared folder;
          2. example: %windir%\System32\wbadmin.exe
            1. start backup -backupTarget:\\backup-device\Archives\Backup -include:c:\data,a:\lau,b:\li -user:machine\account -password:password -vssFull -quiet
  2. Synchronize time with external NTP server on Windows Server 2008 (R2)
    1. Quick Easyfix – How to configure an authoritative time server in Windows Server
      1. Background: System / DC runs 2 to 3 minutes faster than the standard time;
      2. Run the Easyfix program at DC, input as server1;
      3. then, at command prompt, net stop w32time && net start w32time;
      4. Finally, the system will auto gradually sync with ntp server in 24 hours;
    2. First, locate your PDC Server. Open the command prompt and type: C:>netdom /query fsmo
    3. Log in to your PDC Server and open the command prompt.
    4. Stop the W32Time service: C:>net stop w32time
    5. Configure the external time sources, type: C:> w32tm /config /syncfromflags:manual /manualpeerlist:”,,”
    6. Make your PDC a reliable time source for the clients. Type: C:>w32tm /config /reliable:yes
    7. Start the w32time service: C:>net start w32time
    8. The windows time service should begin synchronizing the time. You can check the external NTP servers in the time configuration by typing: C:>w32tm /query /configuration
    9. Check the Event Viewer for any errors.
    10. HK NTP server:
  3. Build 2nd Domain Controller and transfer roles
    1. Build and Deploy the Second Domain Controller:
      1. Estimate and prepare.
        1. Determine AD domain and forest functional level:
          1. Select “Active Directory Domains and Trusts
          2. Right-click the root domain > “Properties“.
          3. Under the “General” tab, the “Domain functional level” and “Forest functional level” is displayed on the screen
          4. Verify adprep /forestprep & /domain prep results.
      2. Install with UI.
      3. Join as domain member
      4. Install DNS service
      5. DCPromo: Additional DC for an existing domain
      6. For additional resilience, configure DC2 to be a global catalog server
        1. AD Sites and Services
        2. Default-First-Site-Name
        3. Servers -> NTDS Settings -> Properties -> Global Catalog -> OK
      7. Transfer DC roles (Operations Master Roles.
        1. Global Catalog Server
        2. Schema Master
          1. Scope: forest-wide
          2. Permission: Schema admin
          3. By AD Schema snap-in (install and register before use)
        3. Domain Naming Master (forest-wide)
          1. Scope: forest-wide
          2. Permission: Enterprise admin
          3. By AD Domains and Trusts -> Change AD DC -> Change -> Yes.
        4. Primary domain controller (PDC) emulator operations master
          1. Scope: domain-wide
          2. Permission: Domain admins
          3. By AD Users and Computers -> Change AD DC -> OK -> All Tasks > Operations Masters > Change > Yes
        5. Relative ID (RID) operations master
          1. Scope: domain-wide
          2. Permission: Domain admins
          3. By AD Users and Computers -> Change AD DC -> OK -> All Tasks > Operations Masters > Change > Yes
        6. Infrastructure operations master
          1. Scope: domain-wide
          2. Permission: Domain admins
          3. By AD Users and Computers -> Change AD DC -> OK -> All Tasks > Operations Masters > Change > Yes
      8. Verification, and must ensure replications to all DC in domains
        1. Search and Open Ntdsutil (Machine with AD service only) as an administrator
        2. ntdsutil: roles
        3. fsmo maintenance: connections
        4. server connections: connect to server cycn-dc01
        5. After confirmation of connected, type: quit
        6. fsmo maintenance: select operation target
        7. operations target: list roles for connected server
        8. quit
      9. Seize the Operations Master Role by ntdsutil.exe if owner DC is unavailable:
      10. References
        1. Installing an Additional Domain Controller by Using the Graphical User Interface (GUI).
        2. View the Current Operations Master Role Holders.
        3. Transfer the Schema Master.
        4. Transfer the Domain Naming Master
        5. Transfer the Domain-Level Operations Master Roles.
  4. Tools
  5. References
    1. Centralizing Windows Logs (Windows Event Subscription).
    2. Audit Windows 2008 file deletion.
    3. How to track and audit file deletion.
    4. Wbadmin backup.
Server / System administration