Need Someone to design and implement a Mobile Application

You need to design and implement a Mobile Application based on your choice. Database Implementation is the most important part of the Project:
1.
• Define the project problem domain
• Highlights the enterprise requirements and user roles
• Describe briefly the enterprise functional specifications and related data
• Depict the schedule for different deliverables and milestones
• Mention about the tools used for design and developing the system
2.
• Business Model
• Explaining system functionalities by describing one by one
e.g. in terms of scenarios or use-cases
• From scenarios or use-cases identifying the following concepts:
• Entities
• Relationships
• All related attributes
• Depicting initial entity relationship (ER) diagram.
• Transforming ER model into Relational Model;
• Entities and Relationships into Tables
• Defining the integrity constraints
3.
• MS. SQL Server
• Create tables based on the relational schema diagram
• Define integrity constraints (PK/FK) based on relational schema diagram
• Define stored procedures for entering sample data into tables
• Input sample data using the stored procedure
• Implement views based on specification mentioned in the Designed Document
• Create script file (.sql) to share your implementation.
4.
Including everything regarding your project
• Proposal,
• Progress reports,
• Diagrams
• ER Models
• Tables
• Views
• Screenshot
5.
Must include
• DDL
• PK
• FK
• Insert
• Alter
• Query
• String operations
• Order by
• Set operations
• Union, interest, except
• Aggregate functions
• Nested subqueries
• Modification
• Deletion
• Insertion
• Updating
• Join operations
• Views
• Integrity constraints
• Index
• Authorization
• User-defined functions
• Procedures
• Triggers
• Ranking
• Windowing
• OLAP
• Rollup