250 likes | 375 Views
Team 5 Molecular and Cellular Biology Lab Database Hank Dong ● Brian Kwon ● Joonyoung Lee ● Juyoung Lee Nina Revko ● James Yein ● Calvin Teng. CLIENT PROFILE. Conducts contract-based in vitro and in vivo research Focuses on testing of newly invented drugs
E N D
Team5 Molecular and Cellular Biology Lab Database Hank Dong ●Brian Kwon ● JoonyoungLee● JuyoungLee Nina Revko ● James Yein● Calvin Teng
CLIENT PROFILE • Conducts contract-based in vitro and in vivo research • Focuses on testing of newly invented drugs • Has no current database support
REVISIONS a brief history
OVERVIEW the data stored
DATA: COMPANY • Storing: Supplier, Customer, Murigenics Employee • Keep details of contacts • Keep employee information
DATA: INVENTORY • Storing: Inventory Collections, Inventory Instances, Orders • Keeps track of inventory {available, in use, in incoming orders} • Stores details on collections and instances
DATA: PROJECTS • Storing: Experiments, Activities, Results • Keeps track of activities in experiment, experiments in projects • Keeps track of results of activities, results of entire project • Export results for analysis in Excel
UX:FORMS Add Employee
UX: FORMS Add Result Add Experiment
UX:FORMS Add Activity Add Supplier
UX:REPORTS Project Report
UX:REPORTS Employee Paycheck
UX:REPORTS Employee Info Report
QUERIES knowing more
Inventory Management VBA • Select Planned Projects 2. Display Required Inventory 3. Behind The Scenes SQL
Service Level • Allows to monitor reputation among clients • Is based on the timely completion of projects and customer surveys SQL Do GOOD, Do WELL, Be ON TIME
FORMS: 2NF • Inventory In Order – Quantity Received • Room Location – Room Name
FORMS: 3NF&BCNF • All 3NF forms are BCNF in our database • No tables with numerous prime fields
THE END Thanks For Coming!