ISE 519 Database Applications in Industrial and Systems Engineering
3 Credit Hours
Rapid applications development (RAD) tools to design and implement database-based applications. The SQL database query language, a standard RAD environment and how to access information in a database from it, use of Visual Basic for Applications, and how to integrate these tools together to design and build engineering applications. Examples will be from manufacturing and production systems.
Prerequisite
Students enrolling in the ISE 519 course should have graduate standing. All students should have had a programming course and are familiar with fundamental programming constructs.
Learning Outcomes
Upon completion of this course, students will be able to:
- Explain the structure, operation, and use of relational database technology applied to production and manufacturing.
- Identify different database solutions for different industry scenarios.
- Design and build a database to hold production data.
- Build form sets/screens that capture process and display information by interacting with a
database through SQL queries - Use Rapid Application Development (RAD) tools to design and build an application.
- Formulate and execute complex SQL queries to retrieve information from a database.
- The ability to generate plots and charts using SQL queries to organize the data.
- Store and display image data in a database.
- Integrate these tools together to design and build engineering applications.
- A knowledge of cloud database services, migration options, and potential use case scenarios.
- Combine the techniques, modern engineering tools, and skills learned to actively contribute to complex application designs utilizing a DBMS in engineering, manufacturing, and general industry use cases.
Grading
| Details and timing of feedback | Percentage of grade |
| Exam 1 (take the exam) | 20 % |
| Exam 2 (take the exam) | 20 % |
| Homework assignments. Average score with each equally weighted. Average is scaled to 100. | 25 % |
| Project (30% presentation, 70% project report) | 35 % |
| Final comprehensive exam is optional (it can be used to replace a low exam score) | optional |
Students must see either myself or the TA about grading questions within 1 week of when we return an exam. After that period, we will not regrade and exam.
Textbook
Required textbook
None.
Technology Requirements
NC State University Libraries offers Technology Lending, where many devices are available to borrow for a 7-day period. Computer labs are available in various locations around campus for student use.
Software and digitally hosted course components
The following software and tools will be used in this course. Some tools are a part of NC State’s
enterprise tools. See information about their purpose, how to access them, accessibility information, and privacy policies. The same information for any other tools required in this course is provided on the list below.
● The database used for this semester will be Microsoft Access 2016 Microsoft Access 2016
and its corresponding RAD environment. If time permits, we will discuss and experiment with
some cloud databases.
● In addition to Microsoft Access 2016, Microsoft Excel and Microsoft PowerPoint will be used.
Microsoft Visio can be used for modeling. Students have the option to use Microsoft PowerBI
for reporting.
Updated 1/16/2025