Need store the invoice details
I normally bill my customers on an annual basis but I do have some customers who like to be billed either monthly or quarterly that I would like to cater for. I hold normal customer details about my customers, such as Name, Address Details, Phone Number. I would also like to hold further details such as email address, billing preference (such as email or letter), and billing period.
All of my water connections are metered and some of my customers have a number of meters for different connections, however most customers only have one meter. I try to capture some information about each meter, such as Meter Address, Type, Installation Date, Serial Number, Initial Reading Value - (this is because the meters are not always at zero when they are installed).
In addition to your data model you should outline the business rules that you have used to form the basis of your design.
Provide reasons to support your design decisions.
<STUDENTID>.DATABASE_OBJECTS.SQL - starts with a CREATE DATABASE statement and then creates all database objects within your database. The database should be named as per your STUDENT NUMBER.
<STUDENTID>.POPULATE_DATA.SQL - SQL script to populate your data model with a sample set of data as follows :
Please make the data realistic – it will be used to test your data model.
Populate Data Script should conform to Data Integrity constraints present within your system.
List all Customers with multiple Meters
Assume that all meter readings are collected on 1st January each year - please supply the following :