Task: It is a tempting to create and implement a desktop application bound to a database using ado.net and managing data through performing SQL transactions. Choose an interested area (health, sports, academic, business, market, pharmacy, school music, etc.) and build a desktop application that will clearly represent this area; try to implement everything you have been studied in this course. Assessment Criteria: 30%: Design, functions. 20%: Database 50%: Dealing with the Code.

Task: It is a tempting to create and implement a desktop application bound to a database using ado.net and managing data through performing SQL transactions. Choose an interested area (health, sports, academic, business, market, pharmacy, school music, etc.) and build a desktop application that will clearly represent this area; try to implement everything you have been studied in this course. Assessment Criteria: 30%: Design, functions. 20%: Database 50%: Dealing with the Code.

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 3PSE

See similar textbooks

Similar questions

A new movie theater has opened in your town and the owner needs a system that facilitates theReservation of seats in the cinema’s auditorium. Design a windows application Form thatFacilitates the reservation of tickets for this Movie Theater.Design and connect the following database using LINQ or Entity Framework for the givenscenario.Database:Movie (id (PK), name, description )ScheduleMovie (id (PK), movieID (FK), time, price)Seat (id (PK), number, rownumber, columnnumber)Reservation (id (PK), scheduledMovie(FK), seatnum(FK), customerId(FK), haspaidTicket)Customer (id (PK), email, name)The user of this application is a cinema staff, for example the admin and the Cashier.The Admin Panel The admin registers the cashiers and also, add new movies when released. The panel has various menus named Add, Remove, and detail Add menu has sub menu named AddMovie, and AddCashier. Remove menu has sub menunamed removeMovie and removeCashier. Click event raised on the click of AddMovie which…
What are the four basic types of operations for a database application? a. Insert, Select, Update, and Delete b. Insert, Update, Delete, and Create c. Insert, Update, Delete, and Render d. Insert, Select, Update, and Render If stringa="Good Morning", what is the value of stringa[1:5]? a. "Good " b. "ood " c. "Good" d. "ood M" The instance that “a survey respondent in service occupation (x) is less likely to report income ” is an example of __________ . a. Missing completely at random. b. Missing at random. c. Missing not at random. d. None of the above.
A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. She has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested:The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (eg animal, landscape, seascape, naval, still‐life, etc). A customer may hire the same painting more than once. Each painting is allocated a monthly rental price. Each painting can only have one artist associated with it. 1. Draw an ER Diagram which includes all details…
A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies.   Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (e.g. animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting…
A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies.   Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (eg animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting is…
A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies.   Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (e.g. animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting…
AssignmentA local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. She has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested:The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (eg animal, landscape, seascape, naval, still‐life, etc). A customer may hire the same painting more than once. Each painting is allocated a monthly rental price. Each painting can only have one artist associated with it. 1. Draw an ER Diagram which includes all…
Respond to parargaph below with one scholarly paragraph with constructive criticism. My first choice was database management would be GUI ( graphical user interface).GUI has been considered the standard of user-centered design, providing users with the ability to interact and operate electronic devices. It's more user-friendly than CLI ( command line interface ). GUI is easier to use and learn, offering immediate visual feedback. GUI has the option for creating scripts using programming software, making programming easier for someone who doesn't know all the syntax or commands. The ability for remote computer access is available with a graphical user interface, making it easier for professionals to manage servers and access computers remotely.
Which of the following is a key feature of a transactional database? a.) This type of database is optimized to execute a small number of complex queries. b.) This type of database is often denormalized with a focus on performance. c.) This type of database generally only has data loads with extremely rare updates or deletes to the data. d.) This type of database is used to process day-to-day operations in real time.
Computer Science When it comes to maintainable database persistence, a common code smell is... a. not using Future callbacks for the database-specific code found throughout our application b. not closing the database after each transaction c. using lower-case String literals for our SQL statements d. placing database-specific code in multiple places throughout our application codebase
what is the role of quesry processor in the database system architecture? a) It send result back to the application that requested the quires b) It translates instruction into file system commands c) It writes log records before applying changes to the database d) It uses information from the catelog to perform query optimization.
The Plaza is an apartment rental company that would like to create an online management system to keep track of apartment complex units, tenants, maintenance requests, and rental payment information. Since you are taking a database class, you are asked to assist the company in designing a database based on the following specifications. Each apartment unit has a unique number.Each unit's street number,street name, city, state zip code, number of bedrooms, monthly rent, and occupancy status are recorded. Each tenant must lease at least one apartment unit for a period of time. It is important to document the lease start date and end date. The Plaza tracks each tenant's name, SSN, home mailing address, and phone number. Each tenant is assigned a unique identifier number. Each tenant should pay the monthly rental fee by the first day of each month.Any rent due not paid by the 4th day of the monthly rental period is subject to a $50.00 late fee charge with an additional $10.00 for…