- Governing Body
- Faculty Members
- Non-Faculty Members
- Unit Coordinators
- Students’ Union
- Cell Members
- AQAR 2010-2011
- AQAR 2011-2012
- AQAR 2012-2013
- AQAR 2013-2014
- AQAR 2014-2015
- AQAR 2015-2016
- AQAR 2016-2017
- AQAR 2017-2018
- AQAR 2018-2019
- AQAR 2019-2020
- AQAR 2020-2021
- AQAR 2021-2022
- AQAR 2022-2023
- Subjects Offered
- Admission Information
- Admission Criteria
- Important Dates
- Offline Registration
- Online Registration
Assignments
- High School
- You don't have any recent items yet.
- You don't have any courses yet.
- You don't have any books yet.
- You don't have any Studylists yet.
- Information
BCAS 1ST Semester Assignment 2022
Hnd it (hnd 53), british college of applied studies.
Preview text
A b s t r a c t 1.
PART: 1 1 Prepare a presentation to present to the management by clearly identifying the user’s requirements and the minimum system requirement to implement the system User requirements:
When a project's use cases are being discussed, user requirements are often written. The
Customer or product managers who are familiar with how the user will utilize the embedded, system help define the requirements. multiple user requirements are concerned with how a user, will utilize a system and what that user would expect., customer: customers may register on the portal. as the details consist of first name,, last name, phone number, e-mail address, purchased book, and when the purchase was, employee: the manager and the assistant manager get reports about each employee's, details. the details consist of first name, last name, address, phone number, hire date,, and position in the store., author: currently, the supervisor keeps records of about 250 authors. they consist of, the author’s first name, last name, year of birth, a year of death., book: the details of each book must contain the following: title, author, cost,, purchase price, rating, publisher, and publication date..
System Requirements:
The system requirements are the configurations that a system must have in order for a piece of
Hardware or software to function properly. if these conditions are not met, installation or, performance issues may occur. the former may prevent a device or application from being, installed, whereas the latter may cause a product to malfunction, perform inadequately, hang, or.
Database server:
operating: The operating system and hardware must meet Oracle 12c database
Software requirements., system: windows server 2012 r2 standard from microsoft., database: oracle real application clusters 12.1.0 or oracle database server (rac)., processor: intel xeon class or higher cpu cores running at 3 ghz or more, memory: 8gb ram or more., computer system., minimum processor or cpu speed., minimum video memory or gpu., full-featured system memory (ram), minimum available storage..
User requirements and system requirements in a database
What the user should perform is specified by user requirements. System requirements
Include non-functional requirements like "the system should handle 100000 users at the, same time," as well as how the user will fulfill user requirements when engaging with the, 1 analyze and design a relational database system for the given scenario.
draws an ER-Diagram with clear explanations and with valid assumptions. Using MySQL Workbench Tool. Indicate the designing steps Conceptual, Logical, and Relational Mapping with Normalization.
- Database tables..........................................................................................
There are five tables in this database. Each table has a primary key. Customer Details
Customer ID
FirstName Last Name Telephone Number Mail Address Employee Details
Employee ID
Phone number, date of birth.
My SQL Workbench tool:
Database normalization
1 st Normalization form
The table below is in the 1st normalization form. In this table, we can see the data duplication
And ordered data records, so we have to solve all the problems in the 2nd normalization form., bookid book_name author name, b1234895 clean code rober martin, b1234896 code complete erich gamma, b1234898 sql computer programming steve mcconnell, b1234899 networking steve mcconnell, b1234901 design pattern damon parker, b1234895 clean code tom johnston, b1234898 sql computer programming bipin desai.
2 nd Normalization form.
In this normalization, form tables will be split and new tables will be created
Bookid book name authorid author_name y.o, b1234895 clean code 12 rober martin 1852., b1234896 code complete 13 erich gamma 1840., b1234898 sql computer programming 14 steve mcconnell 1890., b1234899 networking 14 steve mcconnell 1890., b1234901 design pattern 16 damon parker 1920., b1234895 clean code 17 tom johnston 1930., b1234898 sql computer programming 18 bipin desai 1902., book id book name, b1234895 clean code, b1234896 code complete, b1234898 sql computer programming, b1234899 networking, b1234901 design pattern.
1 Produce a report by evaluating the proposed database system concerning the user and system requirements
About the bookstore management system
The software known as book store management system is used to computerize all systems, and processes in book stores. the management of the books in the bookstore is the focus of, this software. order processing, stock management, and accounts management are generally, included. this software was created by us to keep records of personnel, purchasing, and sales, records. the web application was used as the front end of this project, and sql server was, used as the back end. here, we're attempting to create a system that will offer functionality to, any kind of bookstore. that describes a store that offers its consumers the option to easily buy, books from the store thanks to its type system., the dealer's tab also saves the price paid to a specific dealer from whom the book was, purchased. to compile the reports required by management under the current book store, management system, substantial record-searching is necessary. since information (including, names, phone numbers, and addresses) constantly changes, the registers for the management, of suppliers and employees must be updated from time to time. the number of books currently, in stock in the store is displayed in the stock section. a bill is created when a customer, purchases a book from the retailer. the name of the book purchased, the price per book, the, quantity, the total price, and the total amount are all listed on the bill., user interfaces, the management of the bookstore serves as the system admins. bookstore cashiers as typical, administrators of systems., by entering the administrator user name and password, the administrator logs into the system., administrators have complete control over all database operations, including creating, editing,, and deleting new users, objects, and other transactions., maintainability, the user manual and the system manual are included at delivery to make it easier for the book, shop managers to maintain the system. each module has its own separate design, allowing for, simple modification of a request in the event of a change., only administrators are permitted to make changes to the information in the users and items, tables. without a username and password, no one can access the system. the administrators, login is inaccessible to regular system users. a dialog box requesting confirmation of the, deletion is displayed after every delete action., the wholesale and retail locations are managed manually. all records pertaining to products,, sales, publishers, orders, and payments are kept in excel files that the customer uses. there is, a lot of attempt duplication and room for error. when the records are changed, each excel file, must be updated. in the case of customer records, all information about the customer and the, item they purchased should be saved in the customer's excel files. if the customer profile (such, as phone number or address) changes, the excel file must be updated., the employee keeping records must exert a considerable deal of effort to manage the entire, data. for each distinct process, many excel files must be kept up to date. finding previously, saved records is not a choice. anyone can access any report and sensitive data because there, is no security., purpose of the richard book house management system., this book shop management system is used to fix every issue they are now having by, converting from a manual to a computerized system., purposed the management system for bookstores should make it easier for customers to check, whether a book is in stock. users can check a book's availability using either the title or the, author of the book. my project, the book shop management system, has as its goal and focus, the detailed tracking of user activity. it streamlines the process and minimizes paperwork. the, management system for a bookstore should be able to produce sales figures for any time, period, including the title, publisher, book id, number of copies sold, and sales revenue., if a customer requests a book but the bookstore does not already sell it, the customer is, required to give all the book's details so that the bookstore can order it. if there are any copies, of the requested book left, the exact quantity including the rack number where it is kept should, be indicated. if a book is out of stock, a request field for the book is incremented using the query, for the book. in the intended method, the salesperson would enter the isbn number of the, books as soon as the buyer made his selection for purchase. the stock should be updated and, a sales receipt for the book should be generated by the book store management system., richard book house management system modules., the admin module., module for book details., module for customer details., module for employee details..
Master tables: Book
Author Employee Customer
Account created for the manager: Account created for the assistant manager: creating access to update results in the employee table: create access to select records in the employee table: MIS reports.
- User requirements............................................................................................
- System requirements.......................................................................................
- Database server..............................................................................................
- User requirements and system requirements in database........................................
- Database tables.............................................................................................
- Entity relationship diagram for the database.........................................................
- My SQL workbench tool....................................................................................
- 1 st normalization..............................................................................................
- 2 nd normalization.............................................................................................
- 3 rd normalization............................................................................................
- About the bookstore management system...........................................................
- User interfaces..............................................................................................
- Administrators of system.................................................................................
- System users................................................................................................
- Maintainability...............................................................................................
- Security.......................................................................................................
- At present.....................................................................................................
- Purpose of the Richard books management system.............................................
- Richard book house management system modules..............................................
- Multiple Choice
Course : Hnd IT (HND 53)
University : british college of applied studies.
- Discover more from: Hnd IT HND 53 British College of Applied Studies 43 Documents Go to course
- More from: Hnd IT HND 53 British College of Applied Studies 43 Documents Go to course