- OTHM Level 5 Unit H/650/1142 Professional Supervision Assignment: Health & Social Care Case for Managing Supervision and Performance
- ATHE Level 4 Unit 15 Software Testing Frameworks Assignment: TDD and BDD Strategy for Medical Data Validation Script in Python
- ATHE Level 4 Unit 12 Web Design and Programming Assignment: CTO Birdwatching App Development for Urban Wildlife Insights
- ATHE Level 4 Unit 21 Synoptic Computing Project Assignment: Smart Parking App Design for Urban Mobility Solution
- ATHE Level 4 Unit 1 IT Systems Development Assignment: The World of Art Case Study for Global Online Sales Expansion
- CYP6032 Leading Multi-Agency Health & Social Care Assignment: Vulnerable Groups Literature Review and Reflective Evaluation
- Unit 21 – L/618/8101 Geotechnical Design Assignment 1: Scunthorpe Station Overpass & Bridge Infrastructure Proposal
- Y/616/7445 Unit 039 Diabetes Awareness Assignment: Understanding, Managing and Supporting Individuals with Diabetes
- DHCS 12 (M/650/5189) Understand Mental Ill Health Assignment: Explore DSM/ICD Disorders, Discrimination & Capacity
- Unit 8 Social Media Strategy Assignment 2: Planning, Execution & Evaluation for Organisational Growth
- CIPD Level 7CO01 Strategic People Management Assignment: Demographic Trends, Legal Reforms, Innovation & Resilience in the Workplace
- Financial Accounting Assignment: Lee’s Sole Trader Transactions & Cash Flow Analysis
- L/508/4603 NCFE Level 3 Sport and Exercise Massage Assignment 3: Consultation & Technique Review for Two Contrasting Athletes
- F/650/1141 Unit 4 Team Management and Recruitment Assignment: Health & Social Care Case Study for Effective Leadership and PDPA-Compliant Hiring
- R/650/1138 OTHM Level 5 Assignment: Working in Partnership in Health and Social Care
- NVQ Level 3 Health and Safety Risk Management Assignment: Practical Assessment and Workplace Application
- MBA7068 Strategic Portfolio Assignment 1: Global Business Trends and Managerial Skill Development
- Mechanical Services Innovation: Hotel Rotation Case Study for Energy-Efficient Heat Pump Integration
- K/618/4170 ATHE Level 3 Unit 4 Assignment: Working in Health and Social Care
- T/618/4169 ATHE Level 3 Unit 3 Assignment: Human Growth and Development in Health and Social Care
Use an appropriate design tool to design a relational database system for a substantial problem: International School of Management and Technology Assignment, BU, UK
| University | Bournemouth University (BU) |
| Subject | International School of Management and Technology |
Learning outcomes
- Use an appropriate design tool to design a relational database system for a substantial problem.
- Develop a fully functional relational database system, based on an existing system design.
- Test the system against user and system requirements.
- Produce technical and user documentation.
Scenario
International School of Management and Technology (ISMT) offers internationally recognized British Degrees for those who seek an affordable route to a British Degree without compromising on the quality. To support the students, the School offers a library that has over 2500 titles, 1000 + Magazines, and over 500 copies of Journals. To maintain and manage the
books, the school needs an application that could help the librarians and the students to get the books in and out of the school. The librarians should be able to add books, post if the books are available or not, let the students borrow and receive the books whereas the students should be able to borrow and return books. The application should be able to record the borrow dates and returned dates too.
The Entities required should include at least: Student, Book and Borrow.
The entities are related as follows: A student should be able to know if a book he is looking for is available in the library or not. If the book is available, he should be able to borrow the book. One student should be able to borrow multiple books
You are encouraged to add other related entities you think are required in the system on your own. One Id column, Primary Key with Identity Property should be assigned in each table, Foreign keys must be added based on your design. The database should include at least the following features
- • User details with username and password
- Student details with Student Name, Address, Contact, etc.
- Book details with Book Name, Author, Type, etc.
- Borrow details with Borrow Date, Return Date, etc. For reporting you have to create some stored procedures as follows:
- Year-wise book borrowers.
- Bookwise borrowers within a date range
- Borrow history with Student details
Buy Answer of This Assessment & Raise Your Grades
Students Assignment Help UK is considered as the first-class essay writing help to boost your academic rank in all subjects. We have a bunch of university assignment helpers who provide trustworthy support on HND,HNC, economics, management, and CIPD assignment at the lowest price.
Answer
