Unit 1 │ DATABASE CONCEPTS
Unit 1 │ DATABASE CONCEPTS
Embedded Files
What is information management?
What is information management?
Information management is the collection, storage, management and maintenance of data and other types of information.
It involves the gathering, dissemination, archiving and destruction of information in all its forms. Information management covers the procedures and guidelines organizations adopt to manage and communicate information among different individuals, departments and stakeholders.
Information management focuses on the level of control an organization has over the information it produces. It requires building dedicated information management systems designed to help the company use its resources to support business processes.
Information management also deals with how the organization shares and delivers information to diverse recipients. This includes the format, such as digital and physical information, and the medium, including computers, servers, websites, social media, mobile devices and applications.
UNIT 1.pptxPRESENTATION
VIDEO LECTURE
database concepts.pptPRESENTATION
Unit 2│ REQUIREMENT ANALYSIS
Unit 2│ REQUIREMENT ANALYSIS
requirement analysis.pptPRESENTATION
ASSIGNMENTS
Assignment #2.1: Employee
Assignment #2.2 : Artworks
Lectures
Lectures
UNIT 1 - UNIT 5
Midterm Coverage
Assignment #2.3 Automobile repair shop
Assignment #2.4 :Video Store
Unit 3│ CONCEPTUAL DATA MODELLING
Unit 3│ CONCEPTUAL DATA MODELLING
VIDEO LECTURE│ ERD
VIDEO LECTURE │ERD WITH LUCIDCHART
Unit 4│ LOGICAL DATABASE DESIGN
Unit 4│ LOGICAL DATABASE DESIGN
CROWS FOOT and CHEN MODEL
Unit 5│ RELATIONAL DATABASE MODELING
Unit 5│ RELATIONAL DATABASE MODELING
NORMALIZATION
NORMALIZATION
Basic Concept of Database Normalization
Basic Concept of Database Normalization
First Normal Form (1NF) | Database Normalization | DBMS
Second normal Form
Second normal Form
Third normal Form
Third normal Form
Boyce-Codd normal Form(BCNF)
Boyce-Codd normal Form(BCNF)
4th Normal Form
4th Normal Form
5th normal form
5th normal form
DBMS KEYS
DBMS KEYS
Design Database Tables
Design Database Tables
DAtabase normalization Examples
DAtabase normalization Examples
Given the above Sales records, normalized the table to 1nf,2nd,3rd nf and 4nf.
Given the above Sales records, normalized the table to 1nf,2nd,3rd nf and 4nf.
Normalization Exercises
Take a screenshot of your summary of grade last semester then write down all the included attributes in your excel file.
activities
activities
Assignment ACTIVITIES
Assignment ACTIVITIES
activities
activities
Convert your logical design of your case assignments to physical design. You can use MYSQL Server, MS Access or Microsoft Sql Server. Install your chosen DBMS and create your physical design. Submit your 3-5 minute video link thru my email while doing at least one physical design of your assignments using your chosen DBMS. Submit it on or before 12:30pm.Thank you.
Physical Data Model
Physical Data Model
Physical Data model 1
Physical Data model 1
View this at 8:15am-8:20am
Physical Data Model 2
Physical Data Model 2
View this at 8:25-8:35
MY SQL INSTALLATION AND TUTORIALS
activities
activities
View the following video links then do the seatwork.(7:30-10:30). We will have our Zoom meeting at 11:00am. Prepare for recitation.
View the following video links then do the seatwork.(7:30-10:30). We will have our Zoom meeting at 11:00am. Prepare for recitation.
Seatwork : May 5,2022 at 12:30 pm)
Seatwork : May 5,2022 at 12:30 pm)
Using #4,#5,#6 and #7 problem in the above given exercises, submit the following :
Using #4,#5,#6 and #7 problem in the above given exercises, submit the following :
- Equivalent business Rules
- Equivalent Business objects, business object characteristics, business relationships and constraints.
- Draw the conceptual data model (Using Crow's Foot and Chen model)
- Draw the logical data model(Using Crow's Foot and Chen model)
Select any free software to draw your ER Diagram.
Page updated
Google Sites
Report abuse