Database Management Systems Project
Dive into the world of database management systems by creating a comprehensive project with your teammate. Explore data items, entities, attributes, relationships, ER models, queries, and implementation using a DBMS. Evaluation criteria include data gathering, entity definition, attribute restrictions, relationships, ER modeling, queries, implementation, report writing, and presentation skills. Get ready to showcase your project during the final week of the semester!
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Term Projects Follow the following steps in your term project: Choose your teammate (groups of two at most) Choose a title, e.g. Library Database Send your team members, project title by email to me. Database Management Systems, Roya Choupani 2/27/2025 1
Term Projects Create a list of data items that will be stored in your project. For example, in library project, you may ask the library. Items need not be put in any order. Find and list all entities. Find the attributes of entities (the attributes are data items that you already found) Define restrictions for each attribute (e.g. Number of digits in student ID, range of values for Age attribute, ) Database Management Systems, Roya Choupani 2/27/2025 2
Term Projects Define relationships between entities and their types (Explain how you found the type of the relationships) Create Entity-Relationship (ER) model of your database. Create necessary tables for your database. Show in which normal forms your tables are. Database Management Systems, Roya Choupani 2/27/2025 3
Term Projects Design necessary queries based on the requirements of the project Write necessary SQL commands to create tables and queries Write a report for your project (put all steps explained above) Implement your project using a DBMS (Oracle, MS-SQL, MySQL, MS-Access, ) Database Management Systems, Roya Choupani 2/27/2025 4
Term Projects Evaluation Gathering data items (10) Defining entities, the attributes of the entities, the restrictions on the attributes (15) Relationships (10) ER model (10) Queries (15) Implementation (15) Report (10) Presentation (15) (is necessary) Database Management Systems, Roya Choupani 2/27/2025 5
Presentations Will be during the last week of the semester starting from June 13th , and June 14th The presentation schedule will be sent by email. Database Management Systems, Roya Choupani 2/27/2025 6
