Postgraduate Course: Introduction to web site and database design for drug discovery (BICH11007)
|School||School of Biological Sciences
||College||College of Science and Engineering
|Credit level (Normal year taken)||SCQF Level 11 (Postgraduate)
||Availability||Not available to visiting students
|Summary||This course is designed to give the students an appreciation and some limited experience of the tasks involved in generating a resource for structural data mining.
Large numbers of websites now exist that give access to meta databases that have been derived from chemical or biological structure databases.
This course is about the techniques required for initial dataset selection, mining of the primary data and creation of a database to hold the results of this mining, and then finally the design of a web based interface to provide access to that data.
Current structural databases and their development history.
Data set selection methods, screening for redundancy and source bias
Data set preparation and validation
Techniques for dataset mining.
Database creation and curation.
Website development for database access
Link to a video describing the course from the Course Organiser: https://media.ed.ac.uk/media/Introduction+to+web+site+and+database+design+for+drug+discovery/1_w7abh3sz
Entry Requirements (not applicable to Visiting Students)
||Other requirements|| None
Course Delivery Information
|Academic year 2022/23, Not available to visiting students (SS1)
|Learning and Teaching activities (Further Info)
Lecture Hours 20,
Programme Level Learning and Teaching Hours 2,
Directed Learning and Independent Learning Hours
|Assessment (Further Info)
|Additional Information (Assessment)
||An essay based on description of possible database and web implementation of a current published biological web site will account for 50% and a practical exercise consisting of a database development project will account for the other 50%.
||Notes on the essay and website will be given.
|No Exam Information
On completion of this course, the student will be able to:
- Describe the technologies that underpin current structural or biological databases
- Demonstrate the ability to successfully mine a small example dataset.
- Construct a relational database system to contain that data.
- Construct web pages to allow access to that database.
- Analyse a biological database and propose an appropriate relational database structure to represent it, and a web application to access that database.
|Graduate Attributes and Skills
||Database management and Web site development
|Course organiser||Dr Paul Taylor
Tel: (0131 6)50 7058
|Course secretary||Mrs Claire Black
Tel: (0131 6)50 8637